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)); }