//Insert New Record private void btnSave_Click(object sender, System.EventArgs e) { clsPOSDB dp = new clsPOSDB(); DPDetails dpDetailRec = new DPDetails(0, txtDeliveryPointName.Text, txtDeliveryPointAddress.Text); EnableButtons(); int iEmpId = dp.InsertDeliveryPoint(dpDetailRec); if (iEmpId != -1) { //FrmMain.statusBarMain.Text = "Record Saved Successfully"; //Refresh Display after addition of record and //Display last record inserted UnBindControls(); ShowAllRecords(); BindControls(); this.BindingContext[dpInfo].Position = dpInfo.Length - 1; } else { //FrmMain.statusBarMain.Text = "Save Operation Failed"; } }
public int UpdateDeliveryPoint(DPDetails emp) { SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "procUpdateDeliveryPoint"; cmd.Parameters.Add(new SqlParameter("@DeliveryPointId", SqlDbType.Int)); cmd.Parameters["@DeliveryPointId"].Value = emp.DeliveryPointId; cmd.Parameters.Add(new SqlParameter("@DeliveryPointName", SqlDbType.NVarChar, 20)); cmd.Parameters["@DeliveryPointName"].Value = emp.DeliveryPointName; cmd.Parameters.Add(new SqlParameter("@DeliveryPointAddress", SqlDbType.NVarChar, 20)); cmd.Parameters["@DeliveryPointAddress"].Value = emp.DeliveryPointAddress; try { conn.Open(); int RecordsAffected = cmd.ExecuteNonQuery(); return(RecordsAffected); } catch (SqlException ex) { throw new ApplicationException("Data Error:" + ex); } finally { conn.Close(); } }
public DPDetails GetDeliveryPoint(int DeliveryPointId) { SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "procGetDeliveryPointRec"; cmd.Parameters.Add(new SqlParameter("@DeliveryPointId", SqlDbType.Int)); cmd.Parameters["@DeliveryPointId"].Value = DeliveryPointId; try { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); DPDetails emp; if (dr.Read()) { emp = new DPDetails((int)dr["DeliveryPointId"], (string)dr["DeliveryPointName"], (string)dr["DeliveryPointAddress"]); } else { emp = null; } dr.Close(); conn.Close(); return(emp); } catch (SqlException ex) { throw new ApplicationException("Data Error\n" + ex.Message); } }
//Returns Specific Record private void ShowRecord(int RecordId) { clsPOSDB dp = new clsPOSDB(); DPDetails dpDetailRec = dp.GetDeliveryPoint(RecordId); if (dpDetailRec != null) { txtDeliveryPointId.Text = dpDetailRec.DeliveryPointId.ToString(); txtDeliveryPointName.Text = dpDetailRec.DeliveryPointName; txtDeliveryPointAddress.Text = dpDetailRec.DeliveryPointAddress; } else { //FrmMain.statusBarMain.Text = "Record Not Found"; } }
//Update Record private void btnUpdate_Click(object sender, System.EventArgs e) { clsPOSDB dp = new clsPOSDB(); DPDetails dpDetailRec = new DPDetails(Convert.ToInt32(txtDeliveryPointId.Text), txtDeliveryPointName.Text, txtDeliveryPointAddress.Text); int iRecAffected = dp.UpdateDeliveryPoint(dpDetailRec); if (iRecAffected != 0) { //FrmMain.statusBarMain.Text = "Record Updated Successfully"; } else { //FrmMain.statusBarMain.Text = "Update Operation Failed"; } }
public DPDetails[] GetAllDeliveryPoint() { SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "procGetAllDeliveryPoint"; ArrayList arrEmp = new ArrayList(); try { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); DPDetails emp; if (dr.HasRows) { while (dr.Read()) { emp = new DPDetails((decimal)dr["DeliveryPointId"], (string)dr["DeliveryPointName"], (string)dr["DeliveryPointAddress"]); arrEmp.Add(emp); } } else { emp = null; } dr.Close(); conn.Close(); return((DPDetails[])arrEmp.ToArray(typeof(DPDetails))); } catch (SqlException ex) { throw new ApplicationException("Data Error\n" + ex.Message); } }