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
{
string ctgry;
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)";
ctgry = RdCtgry.SelectedItem.Value.ToString();
try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Val1", drpVno.Text.ToString());
cmd.Parameters.AddWithValue("@Val3", drpDrCode.Text.ToString());
cmd.Parameters.AddWithValue("@Val2", drpEmpCode.Text.ToString());
cmd.Parameters.AddWithValue("@Val4", drpBrCode.Text.ToString());
cmd.Parameters.AddWithValue("@Val5", drpPrps.Text.ToString());
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)
{
ctgry = RdCtgry.SelectedItem.Value.ToString();
if (ctgry == "Commercial")
{
drpEmpCode.Items.Clear();
drpEmpCode.Enabled = false;
chkDr.Enabled = false;
}
else
{
drpEmpCode.Enabled = true;
}
if (ctgry == "Cars")
{
chkDr.Enabled=true;
}
if (ctgry == "Bikes")
{
drpDrCode.Items.Clear();
drpDrCode.Enabled = false;
}
else
{
drpDrCode.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 chkDr_CheckedChanged(object sender, EventArgs e)
{
if (chkDr.Checked.Equals(false))
{
drpDrCode.Items.Clear();
}
}
protected void Button1_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 = "select * from tblalloc where VNo='" + drpVno.Text.Trim() + "'";
SqlDataReader rdr = cmd.ExecuteReader();
//rdr = cmd.ExecuteReader();
bool temp = false;
while (rdr.Read())
{
drpVno.Text = rdr.GetValue(0).ToString();
drpEmpCode.Text = rdr.GetString(2);
drpDrCode.Text = rdr.GetString(1);
drpBrCode.Text = rdr.GetString(3);
drpPrps.Text = rdr.GetString(4);
temp = true;
}
if (temp == false)
MessageBox.Show("not found");
con.Close();
}
}
}
Suniluc, if this helps please login to Mark As Answer. | Alert Moderator