/// <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(ReturnableDCItem objDCItem)
{
bool flgSave = false;
//flgSave = ReturnableDCItemDAL.Save(objDCItem);
return(flgSave);
}
/// <summary>
/// This Method Deletes record from Database.
/// </summary>
/// <param name="objDCItem">Object which is to be Deleted.</param>
/// <returns>Returns boolean value True if record is deleted Successfully
/// otherwise returns false indicating that record is not deleted.</returns>
public static bool Delete(ReturnableDCItem objDCItem)
{
bool recDAL;
recDAL = ReturnableDCItemDAL.Delete(objDCItem.DBID);
return(recDAL);
}
/// <summary>
/// Fills values fetched from Database to Object objDCItem.
/// </summary>
/// <param name="myDataRec">Record Object containing data values.</param>
/// <returns>Returns object ObjDCItem containing Data values from Database.</returns>
private static ReturnableDCItem FillDataRecord(IDataRecord myDataRec)
{
ReturnableDCItem objDCItem = new ReturnableDCItem();
objDCItem.IsLoading = true;
objDCItem.DBID = Convert.ToInt32(myDataRec["DBID"]);
objDCItem.EntryNo = Convert.ToInt32(myDataRec["ENTRYNO"]);
objDCItem.EntryDate = Convert.ToDateTime(myDataRec["ENTRYDATE"]);
objDCItem.EntryType = Convert.ToString(myDataRec["ENTRYTYPE"]);
objDCItem.DCNo = Convert.ToString(myDataRec["DCNO"]);
objDCItem.DCDate = Convert.ToDateTime(myDataRec["DCDATE"]);
objDCItem.ItemCode = Convert.ToString(myDataRec["ITEMCODE"]);
if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("ITEMDESCR")))
{
objDCItem.ItemDescr = Convert.ToString(myDataRec["ITEMDESCR"]);
}
objDCItem.Qty = Convert.ToDecimal(myDataRec["QTY"]);
objDCItem.Qty2 = Convert.ToDecimal(myDataRec["QTY2"]);
if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("UNIT")))
{
objDCItem.UnitName = Convert.ToString(myDataRec["UNIT"]);
}
if (!myDataRec.IsDBNull(myDataRec.GetOrdinal("REMARK")))
{
objDCItem.Remark = Convert.ToString(myDataRec["REMARK"]);
}
objDCItem.MasterDBID = Convert.ToInt32(myDataRec["MASTERDBID"]);
objDCItem.IsNew = false;
objDCItem.IsEdited = false;
objDCItem.IsDeleted = false;
objDCItem.IsLoading = false;
return(objDCItem);
}
private void modifyToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvwItems.SelectedItems != null && lvwItems.SelectedItems.Count == 1)
{
objItemSelected = objDC.DCItems[lvwItems.SelectedItems[0].Index];
LoadItem();
}
}
private void newToolStripMenuItem_Click(object sender, EventArgs e)
{
objItemSelected = new ReturnableDCItem();
DCItem_OnInvalid(sender, e);
FillcboItems();
FillcboUnits();
LoadItem();
cboItemCode.Focus();
}
/// <summary>
/// This method retrieves "ReturnableDCItem" Record from Database.
/// </summary>
/// <param name="dbid">Unique ID value based on which Record will be fetched from Database.</param>
/// <returns>Object "ReturnableDCItem" containing Data Values.</returns>
public static ReturnableDCItem GetItem(int dbid)
{
ReturnableDCItem objDCItem = 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 RETURNABLEDCDETAIL " +
" WHERE DBID = @DBID";
objCmd.Parameters.AddWithValue("@DBID", dbid);
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
SqlDataReader oReader = objCmd.ExecuteReader();
if (oReader.Read())
{
objDCItem = FillDataRecord(oReader);
objDCItem.IsNew = false;
}
oReader.Close();
oReader.Dispose();
}
catch
{
throw;
}
}
}
return(objDCItem);
}
/// <summary>
/// This method Saves Record into Database.
/// </summary>
/// <param name="objDCItem">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(ReturnableDCItem objDCItem, User currentUser)
{
int result = 0;
UserCompany CurrentCompany = new UserCompany();
using (SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString()))
{
string strSaveQry;
if (objDCItem.IsNew)
{
strSaveQry = "INSERT INTO RETURNABLEDCDETAIL(DBID, ENTRYNO, ENTRYDATE, ENTRYTYPE, " +
" DCNO, DCDATE, ITEMCODE, ITEMDESCR, QTY, QTY2, UNIT, REMARK, MASTERDBID, " +
" ST_DATE, MODIFY_DATE, CRBY, MODBY, MACHINENAME) " +
" VALUES (@dbId, @EntryNo, @EntryDate, @EntryType, @DCNo, @DCDate, " +
" @ItemCode, @ItemDescr, @Qty, @Qty2, @Unit, @Remark, @MasterDBID, " +
" @STDate, @ModifyDate, @CrBy, @ModBy, @MachineName)";
}
else
{
strSaveQry = "UPDATE RETURNABLEDCDETAIL " +
" SET ENTRYNO = @EntryNo, ENTRYDATE = @EntryDate, ENTRYTYPE = @EntryType, " +
" DCNO = @DCNo, DCDATE = @DCDate, ITEMCODE = @ItemCode, ITEMDESCR = @ItemDescr" +
" Qty = @QTY, QTY2 = @Qty2, UNIT = @Unit, REMARK = @Remark, " +
" MASTERDBID = @MasterDBID, 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("@EntryNo", objDCItem.EntryNo);
objCmd.Parameters.AddWithValue("@EntryDate", objDCItem.EntryDate);
objCmd.Parameters.AddWithValue("@EntryType", objDCItem.EntryType);
objCmd.Parameters.AddWithValue("@DCNo", objDCItem.DCNo);
objCmd.Parameters.AddWithValue("@DCDate", objDCItem.DCDate);
objCmd.Parameters.AddWithValue("@ItemCode", objDCItem.ItemCode);
objCmd.Parameters.AddWithValue("@ItemDescr", objDCItem.ItemDescr);
objCmd.Parameters.AddWithValue("@Qty", objDCItem.Qty);
objCmd.Parameters.AddWithValue("@Qty2", objDCItem.Qty2);
objCmd.Parameters.AddWithValue("@Unit", objDCItem.UnitName);
objCmd.Parameters.AddWithValue("@Remark", objDCItem.Remark);
if (objDCItem.IsNew)
{
objCmd.Parameters.AddWithValue("@StDate", DateTime.Now);
objCmd.Parameters.AddWithValue("@CrBy", currentUser.LoginName);
//objDCItem.DBID = General.GenerateDBID(Conn, "RETURNABLEDCDETAIL");
objDCItem.DBID = General.GenerateDBID("SEQDCITEMID", Conn);
}
objCmd.Parameters.AddWithValue("@ModifyDate", DateTime.Now);
objCmd.Parameters.AddWithValue("@ModBy", currentUser.LoginName);
objCmd.Parameters.AddWithValue("@MachineName", General.GetMachineName());
objCmd.Parameters.AddWithValue("@dbID", objDCItem.DBID);
objCmd.Parameters.AddWithValue("@MasterDBID", objDCItem.MasterDBID);
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
result = objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
return(result > 0);
}
