public DeliverNote Get(string DeliverNoteID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DeliverNoteNo", DeliverNoteID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_DeliverNoteNoByID", paramList); DeliverNote obj = new DeliverNote(); if (dt.Rows.Count > 0) { obj.DeleveryNoteID = Convert.ToString(dt.Rows[0]["DeliverNoteNo"]); obj.DeleveryNoteEnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["DeliverEnterdBy"])); obj.DeleveryNoteDate = Convert.ToDateTime(dt.Rows[0]["DeliverDate"]); obj.DeleveryNoteEnterdDate = Convert.ToDateTime(dt.Rows[0]["DeliverEnterdDate"]); obj.DeleveryNotePO = Convert.ToString(dt.Rows[0]["DeliverPONO"]); obj.DeleveryNoteStatus = (DeliverNote.Status)(dt.Rows[0]["Status"]); obj.Supplier = Convert.ToInt64(dt.Rows[0]["SupplierCode"]); obj.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(DeliverNote obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DeliverNoteNo", obj.DeleveryNoteID), new SqlParameter("@DeliverDate", obj.DeleveryNoteDate), new SqlParameter("@DeliverEnterdBy", obj.DeleveryNoteEnterdBy.EmployeeID), new SqlParameter("@SupplierCode", obj.Supplier), new SqlParameter("@Remarks", obj.Remarks) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_DeliverNote", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (keyData == Keys.End) { DialogResult TheResult = MessageBox.Show(this, "Have you Finished Entering Details", "Confirmation", MessageBoxButtons.YesNo); if (TheResult == System.Windows.Forms.DialogResult.Yes) { if (objCollec.Count > 0) { DeliverNoteMaterials_DL objDeliverNoteMaterials_DL = new DeliverNoteMaterials_DL(ConnectionStringClass.GetConnection()); DeliverNote obj = new DeliverNote(); obj.DeleveryNoteID = txtDeliverNote.Text; obj.DeleveryNoteEnterdBy = objEmployee_DL.Get(CurrentUser.EmployeeID); obj.DeleveryNoteStatus = DeliverNote.Status.Initial; obj.DeleveryNoteDate = DateTime.Today; obj.DeleveryNotePO = "N/A"; obj.Remarks = txtRemarks.Text; obj.Supplier = Convert.ToInt64(txtSupplierCode.Text); objDeliverNote_DL.Add(obj); foreach (DeliverNoteMaterials tmpobj in objCollec) { tmpobj.DeliverNote = obj.DeleveryNoteID; objDeliverNoteMaterials_DL.Add(tmpobj); } objCollec = null; dgvDeliverNoteList.AutoGenerateColumns = false; objSourceDeliverNotes.DataSource = objCollec; dgvDeliverNoteList.DataSource = objSourceDeliverNotes; objSourceDeliverNotes.ResetBindings(true); txtDeliverNote.Text = ""; txtDeliverNote.Select(); } } return(true); // indicate that you handled this keystroke } if (keyData == Keys.F1) { frmTGRNList objForm = new frmTGRNList(CurrentUser, "Packing"); objForm.ShowDialog(this); } if (keyData == Keys.Escape) { DialogResult Result = MessageBox.Show(this, "Do you want to Exit", "Confirm", MessageBoxButtons.YesNo); if (Result == System.Windows.Forms.DialogResult.Yes) { this.Close(); } } // Call the base class return(base.ProcessCmdKey(ref msg, keyData)); }