using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Text;
using System.Windows.Forms;
namespace BVIS
{
public partial class Allocation : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnCncl_Click(object sender, EventArgs e)
{
Response.Redirect("Default.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
String connectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
SqlConnection con = new SqlConnection(connectionString);
string sql = "INSERT INTO [tblalloc] (VNo,EmpCode,Drcode,BrCode,Purpose) VALUES (@Val1,@Val2,@Val3,@Val4,@Val5)";
try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Val1", drpVno.Text);
string ctgry = RdCtgry.SelectedItem.Value.ToString();
if (ctgry == "Commercial")
{
cmd.Parameters.AddWithValue("@Val2", "");
}
else
{
cmd.Parameters.AddWithValue("@Val2", drpEmpCode.Text);
}
cmd.Parameters.AddWithValue("@Val3", drpDrCode.Text);
cmd.Parameters.AddWithValue("@Val4", drpBrCode.Text);
cmd.Parameters.AddWithValue("@Val5", drpPrps.Text);
cmd.ExecuteNonQuery();
lblMsg.Text = "Insertion Successful";
drpVno.Focus();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
con.Close();
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
lblNew.Visible = true;
txtNew.Visible = true;
btnOk.Visible = true;
}
protected void btnOk_Click(object sender, EventArgs e)
{
drpPrps.Items.Add("txtNew.Text");
lblNew.Visible = false;
txtNew.Visible = false;
btnOk.Visible = false;
}
protected void RdCtgry_SelectedIndexChanged(object sender, EventArgs e)
{
string ctgry = RdCtgry.SelectedItem.Value.ToString();
if (ctgry == "Commercial")
{
drpEmpCode.Enabled = false;
}
else
{
drpEmpCode.Enabled = true;
}
}
protected void btnUpdt_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=E:\\vip\\BVIS\\BVIS\\App_Data\\VehicleDb.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = "UPDATE [tblalloc] SET VNo = @vn, Drcode = @dr, EmpCode= @emp, BrCode=@br, Purpose=@pr WHERE VNo = @vn";
cmd.Parameters.AddWithValue("@vn", drpVno.Text);
cmd.Parameters.AddWithValue("@dr", drpDrCode.Text);
cmd.Parameters.AddWithValue("@emp", drpEmpCode.Text);
cmd.Parameters.AddWithValue("@br", drpBrCode.Text);
cmd.Parameters.AddWithValue("@pr", drpPrps.Text);
cmd.ExecuteNonQuery();
con.Close();
}
protected void drpVno_SelectedIndexChanged(object sender, EventArgs e)
{
bool temp = false;
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=E:\\vip\\BVIS\\BVIS\\App_Data\\VehicleDb.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from [tblalloc] where VNo='" + drpVno.Text.Trim() + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
drpVno.Text = dr.GetValue(0).ToString();
drpEmpCode.Text = dr.GetString(2).ToString();
drpDrCode.Text = dr.GetString(1).ToString();
drpBrCode.Text = dr.GetString(3).ToString();
drpPrps.Text = dr.GetString(4).ToString();
temp = true;
}
if (temp == false)
MessageBox.Show("Not found");
con.Close();
}
}
}
Suniluc, if this helps please login to Mark As Answer. | Alert Moderator