private void createButton_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtTerritoryName.Text))
{
MessageBox.Show("Please select territory Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(txtLocationName.Text))
{
MessageBox.Show("Please select Location Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(txtUserFullName.Text))
{
MessageBox.Show("Please select User as Location In Charge", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
string ct3 = "select LocationIncharge.LocationId from LocationIncharge where LocationIncharge.LocationId='" + locationId + "' and LocationIncharge.RetractDate is null";
cmd = new SqlCommand(ct3, con);
rdr = cmd.ExecuteReader();
if (rdr.Read() && !rdr.IsDBNull(0))
{
MessageBox.Show("This Location has already under one Location InCharge.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Close();
Reset();
return;
}
int mgs;
LocationInChargeManager aManager = new LocationInChargeManager();
LocationInCharges aLocationInCharges = new LocationInCharges();
aLocationInCharges.LocationId = locationId;
aLocationInCharges.LUserId = locationInChargeId.ToString();
aLocationInCharges.AssignDate = dateOfAssignDate.Text;
aLocationInCharges.AssignedBy = lUserId;
mgs = aManager.SaveLocationInCharge(aLocationInCharges);
MessageBox.Show("Successfully Saved", "record", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset();
dataGridView2.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int SaveLocationInCharge(LocationInCharges aLocationInCharges)
{
con = new SqlConnection(cs.DBConn);
con.Open();
// string q = "select FullName,UserId, UserName from Users where Statuss='Active'";
string query = "INSERT INTO LocationIncharge(UserId,LocationId,AssignDate,Assignedby) VALUES(@d1,@d2,@d3,@d4)";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@d1", aLocationInCharges.LUserId);
cmd.Parameters.AddWithValue("@d2", aLocationInCharges.LocationId);
cmd.Parameters.AddWithValue("@d3", aLocationInCharges.AssignDate);
cmd.Parameters.AddWithValue("@d4", aLocationInCharges.AssignedBy);
int affectedRows = cmd.ExecuteNonQuery();
con.Close();
return(affectedRows);
}
public int SaveLocationInCharge(LocationInCharges aLocationInCharges)
{
alGateway = new LocationInChargeGateway();
return(alGateway.SaveLocationInCharge(aLocationInCharges));
}
