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