public DataTable InsertRecord(Objects.CustomerReturn obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_CustomerReturnInsert"; cmd.Parameters.AddWithValue("@ReturnDate", obj.ReturnDate); //cmd.Parameters.AddWithValue("@IssueID", obj.IssueID); cmd.Parameters.AddWithValue("@CustomerID", obj.CustomerID); cmd.Parameters.AddWithValue("@SecurityReturn", obj.SecurityReturn); cmd.Parameters.AddWithValue("@UserID", obj.UserID); cmd.Parameters.AddWithValue("@Remarks", obj.Remarks); return(new Database(connectionstring).ExecuteForDataTable(cmd)); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtCustomerID.Text.Trim())) { MessageBox.Show("Please Select Customer", "Information Missing"); txtCustomerID.Focus(); return; } if (Grid.Rows.Count == 0) { MessageBox.Show("Please Insert Products Information", "Detail Missing"); txt_ProductID.Focus(); return; } decimal vSecurity = 0; decimal.TryParse(txtSecurity.Text, out vSecurity); Objects.CustomerReturn BAL = new Objects.CustomerReturn(); BAL.ReturnID = Int64.Parse(txtInvNo.Text); BAL.ReturnDate = dtEntryDate.Value; BAL.CustomerID = int.Parse(txtCustomerID.Text); BAL.SecurityReturn = vSecurity; BAL.Remarks = txtRemarks.Text; BAL.UserID = vUserID; if (vOpenMode) { objDAL.UpdateRecord(BAL); objDAL.DeleteRecordBody(Int64.Parse(txtInvNo.Text)); } else { DataTable dt = objDAL.InsertRecord(BAL); BAL.IssueID = Int64.Parse(dt.Rows[0]["ReturnID"].ToString()); } //Save Detail foreach (DataGridViewRow dr in Grid.Rows) { if (dr.Cells[0].Value != null) { Objects.CustomerReturnBody objBody = new Objects.CustomerReturnBody(); objBody.ReturnID = BAL.ReturnID; objBody.ProductID = Int32.Parse(dr.Cells["ProductID"].Value.ToString()); objBody.Qty = decimal.Parse(dr.Cells["Qty"].Value.ToString(), System.Globalization.NumberStyles.AllowDecimalPoint); objBody.Cost = decimal.Parse(dr.Cells["Cost"].Value.ToString(), System.Globalization.NumberStyles.AllowDecimalPoint); objDAL.InsertRecordBody(objBody); } } MessageBox.Show("Record Saved Successfully.", "Task Completed"); SetMode(false); } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }