public frmReturnableDCProp(ReturnableDC objDC, User currentUser) { this.objDC = objDC; this.currentUser = currentUser; InitializeComponent(); InitializeListView(); }
private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { try { if (lvwDCList.SelectedItems != null && lvwDCList.SelectedItems.Count != 0) { if (!IsList) { if (objUIRights.DeleteRight) { DialogResult dr = new DialogResult(); dr = MessageBox.Show("Do You Really Want to Delete Record ?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { ReturnableDC objDC = new ReturnableDC(); objDC = ReturnableDCManager.GetItem(Convert.ToInt32(lvwDCList.SelectedItems[0].Name)); ReturnableDCManager.Delete(objDC); lvwDCList.Items.Remove(lvwDCList.SelectedItems[0]); } } else { throw new Exception("Not Authorised."); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void newToolStripMenuItem_Click(object sender, EventArgs e) { try { if (!IsList) { if (objUIRights.AddRight) { ReturnableDC objDC; frmReturnableDCProp objFrmProp; objDC = new ReturnableDC(); objFrmProp = new frmReturnableDCProp(objDC, currentUser); objFrmProp.IsNew = true; objFrmProp.MdiParent = this.MdiParent; objFrmProp.Entry_DataChanged += new frmReturnableDCProp.DCUpdateHandler(Entry_DataChanged); objFrmProp.Show(); } else { throw new Exception("Not Authorised."); } } } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
/// <summary> /// Deletes Record from Database. /// </summary> /// <param name="objRetDC">Object containing all data values.</param> /// <returns>boolean value True if Record is deleted successfully /// otherwise returns False.</returns> public static bool Delete(ReturnableDC objRetDC) { bool recDel; recDel = ReturnableDCDAL.Delete(objRetDC.DBID); return(recDel); }
/// <summary> /// Retrieves ReturnableDC Detail for Specified Record. /// </summary> /// <param name="dbid"></param> /// <returns></returns> public static ReturnableDC GetItem(int dbid, bool flgWithItems) { ReturnableDC objDC = ReturnableDCDAL.GetItem(dbid); if (objDC != null && flgWithItems) { objDC.DCItems = ReturnableDCItemDAL.GetList(objDC.EntryNo, objDC.EntryDate, objDC.DBID); } return(objDC); }
/// <summary> /// Fills values fetched from Database to Object objDept. /// </summary> /// <param name="myDataRec">Record Object containing data values.</param> /// <returns>Returns object ObjDept containing Data values from Database.</returns> private static ReturnableDC FillDataRecord(IDataRecord myDataRec) { ReturnableDC objRetDC = new ReturnableDC(); objRetDC.IsLoading = true; objRetDC.DBID = Convert.ToInt32(myDataRec["DBID"]); objRetDC.EntryNo = Convert.ToInt32(myDataRec["ENTRYNO"]); objRetDC.EntryDate = Convert.ToDateTime(myDataRec["ENTRYDATE"]); objRetDC.EntryType = Convert.ToString(myDataRec["ENTRYTYPE"]); objRetDC.PartyName = Convert.ToString(myDataRec["PARTYNAME"]); if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("vehicleno"))) { objRetDC.VehicleNo = Convert.ToString(myDataRec["VEHICLENO"]); } objRetDC.DCNo = Convert.ToString(myDataRec["DCNO"]); objRetDC.DCDate = Convert.ToDateTime(myDataRec["DCDATE"]); objRetDC.PlantName = Convert.ToString(myDataRec["PLANT"]); if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("vindate"))) { objRetDC.VInDate = Convert.ToDateTime(myDataRec["VINDATE"]); } if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("vintime"))) { objRetDC.VInTime = Convert.ToDateTime(myDataRec["VINTIME"]); } if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("voutdate"))) { objRetDC.VOutDate = Convert.ToDateTime(myDataRec["VOUTDATE"]); } if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("vouttime"))) { objRetDC.VOutTime = Convert.ToDateTime(myDataRec["VOUTTIME"]); } objRetDC.IsNew = false; objRetDC.IsEdited = false; objRetDC.IsDeleted = false; objRetDC.IsLoading = false; return(objRetDC); }
/// <summary> /// This method retrieves "ReturnableDC" Record from Database. /// </summary> /// <param name="dbid">Unique ID value based on which Record will be fetched from Database.</param> /// <returns>Object "ReturnableDC" containing Data Values.</returns> public static ReturnableDC GetItem(int dbid) { ReturnableDC objRetDC = null; using (SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString())) { using (SqlCommand objCmd = new SqlCommand()) { try { objCmd.Connection = Conn; objCmd.CommandType = CommandType.Text; objCmd.CommandText = "SELECT * FROM RETURNABLEDC " + " WHERE DBID = @DBID"; objCmd.Parameters.AddWithValue("@DBID", dbid); if (Conn.State != ConnectionState.Open) { Conn.Open(); } SqlDataReader oReader = objCmd.ExecuteReader(); if (oReader.Read()) { objRetDC = FillDataRecord(oReader); objRetDC.IsNew = false; } oReader.Close(); oReader.Dispose(); } catch { throw; } } } return(objRetDC); }
/// <summary> /// Saves current Object Values into Database. /// </summary> /// <param name="objRetDC">Current Department Object.</param> /// <returns>Boolean value True if record is saved successfully /// otherwise returns 'False' indicating record is not saved.</returns> public static bool Save(ReturnableDC objRetDC, User currentUser) { bool flgSave; using (TransactionScope objTScope = new TransactionScope(TransactionScopeOption.RequiresNew)) { if (objRetDC.IsEdited || objRetDC.IsNew) { ReturnableDCDAL.Save(objRetDC, currentUser); } if (objRetDC.DCItems != null) { foreach (ReturnableDCItem objItem in objRetDC.DCItems) { if (objItem.IsDeleted && !objItem.IsNew) { ReturnableDCItemDAL.Delete(objItem.DBID); } else if ((objItem.IsEdited || objItem.IsNew) && !objItem.IsDeleted) { objItem.EntryNo = objRetDC.EntryNo; objItem.EntryDate = objRetDC.EntryDate; objItem.EntryType = objRetDC.EntryType; objItem.MasterDBID = objRetDC.DBID; objItem.DCNo = objRetDC.DCNo; objItem.DCDate = objRetDC.DCDate; ReturnableDCItemDAL.Save(objItem, currentUser); } } } flgSave = true; objTScope.Complete(); } return(flgSave); }
/// <summary> /// This method Saves Record into Database. /// </summary> /// <param name="objRetDC">Object containing Data values to be saved.</param> /// <returns>Boolean value True if Record is saved successfully /// otherwise returns False indicating Record is not saved.</returns> public static bool Save(ReturnableDC objRetDC, User currentUser) { int result = 0; UserCompany CurrentCompany = new UserCompany(); using (SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString())) { string strSaveQry; if (objRetDC.IsNew) { strSaveQry = "INSERT INTO RETURNABLEDC(DBID, ENTRYNO, ENTRYDATE, ENTRYTYPE, " + " PARTYNAME, VEHICLENO, DCNO, DCDATE, PLANT, VINDATE, VINTIME, VOUTDATE, " + " VOUTTIME, ST_DATE, MODIFY_DATE, CRBY, MODBY, MACHINENAME) " + " VALUES (@dbId, @EntryNo, @EntryDate, @EntryType, @PartyName, @VehicleNo, " + " @DCNo, @DCDate, @Plant, @VinDate, @VinTime, @VOutDate, @VoutTime, " + " @STDate, @ModifyDate, @CrBy, @ModBy, @MachineName)"; } else { strSaveQry = "UPDATE RETURNABLEDC " + " SET ENTRYNO = @EntryNo, ENTRYDATE = @EntryDate, ENTRYTYPE = @EntryType, " + " PARTYNAME = @PartyName, VEHICLENO = @VehicleNo, DCNO = @DCNo, " + " DCDATE = @DCDate, PLANT = @Plant, VINDATE = @VInDate, VINTIME = @VInTime, " + " VOUTDATE = @VOutDate, VOUTTIME = @VOutTime, MODIFY_DATE = @ModifyDate, " + " MODBY = @ModBy, MACHINENAME = @MachineName " + " WHERE DBID = @dbId"; } try { SqlCommand objCmd = Conn.CreateCommand(); objCmd.CommandType = CommandType.Text; objCmd.CommandText = strSaveQry; objCmd.Parameters.AddWithValue("@EntryDate", objRetDC.EntryDate); objCmd.Parameters.AddWithValue("@EntryType", objRetDC.EntryType); objCmd.Parameters.AddWithValue("@PartyName", objRetDC.PartyName); if (objRetDC.VehicleNo == string.Empty) { objCmd.Parameters.AddWithValue("@VehicleNo", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VehicleNo", objRetDC.VehicleNo); } objCmd.Parameters.AddWithValue("@DCNo", objRetDC.DCNo); objCmd.Parameters.AddWithValue("@DCDate", objRetDC.DCDate); objCmd.Parameters.AddWithValue("@Plant", objRetDC.PlantName); if (objRetDC.VInDate == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VInDate", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VInDate", objRetDC.VInDate); } if (objRetDC.VInTime == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VInTime", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VInTime", objRetDC.VInTime); } if (objRetDC.VOutDate == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VOutDate", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VOutDate", objRetDC.VOutDate); } if (objRetDC.VOutTime == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VOutTime", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VOutTime", objRetDC.VOutTime); } if (objRetDC.IsNew) { objCmd.Parameters.AddWithValue("@StDate", DateTime.Now); objCmd.Parameters.AddWithValue("@CrBy", currentUser.LoginName); //objRetDC.DBID = General.GenerateDBID(Conn, "RETURNABLEDC"); objRetDC.DBID = General.GenerateDBID("SEQDCID", Conn); objRetDC.EntryNo = objRetDC.DBID; } objCmd.Parameters.AddWithValue("@ModifyDate", DateTime.Now); objCmd.Parameters.AddWithValue("@ModBy", currentUser.LoginName); objCmd.Parameters.AddWithValue("@MachineName", General.GetMachineName()); objCmd.Parameters.AddWithValue("@dbID", objRetDC.DBID); objCmd.Parameters.AddWithValue("@EntryNo", objRetDC.EntryNo); if (Conn.State != ConnectionState.Open) { Conn.Open(); } result = objCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } } return(result > 0); }