Int64 ICMMeasurementBookDetailDataAccess.Add(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(cMMeasurementBookDetailEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(cMMeasurementBookDetailEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void PrepareEditView()
{
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = CurrentCMMeasurementBookDetailEntity;
if (!cMMeasurementBookDetailEntity.IsNew)
{
txtDescription.Text = cMMeasurementBookDetailEntity.Description.ToString();
if (ddlUnitID.Items.Count > 0 && cMMeasurementBookDetailEntity.UnitID != null)
{
ddlUnitID.SelectedValue = cMMeasurementBookDetailEntity.UnitID.ToString();
}
txtLengthft.Text = cMMeasurementBookDetailEntity.Lengthft.ToString();
txtLenghtin.Text = cMMeasurementBookDetailEntity.Lenghtin.ToString();
txtWidthft.Text = cMMeasurementBookDetailEntity.Widthft.ToString();
txtWidthin.Text = cMMeasurementBookDetailEntity.Widthin.ToString();
txtHeightft.Text = cMMeasurementBookDetailEntity.Heightft.ToString();
txtHeightin.Text = cMMeasurementBookDetailEntity.Heightin.ToString();
txtNos.Text = cMMeasurementBookDetailEntity.Nos.ToString();
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
}
}
private Int64 AddTran(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.CMMeasurementBookDetail_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option, db);
AddOutputParameter(cmd, db);
AddNullPrimaryKeyParameter(cmd, "MeasurementBookDetailID", db);
db.AddInParameter(cmd, "@MeasurementBookID", DbType.Int64, cMMeasurementBookDetailEntity.MeasurementBookID);
db.AddInParameter(cmd, "@Description", DbType.String, cMMeasurementBookDetailEntity.Description);
db.AddInParameter(cmd, "@UnitID", DbType.Int64, cMMeasurementBookDetailEntity.UnitID);
db.AddInParameter(cmd, "@Lengthft", DbType.Decimal, cMMeasurementBookDetailEntity.Lengthft);
db.AddInParameter(cmd, "@Lenghtin", DbType.Decimal, cMMeasurementBookDetailEntity.Lenghtin);
db.AddInParameter(cmd, "@Widthft", DbType.Decimal, cMMeasurementBookDetailEntity.Widthft);
db.AddInParameter(cmd, "@Widthin", DbType.Decimal, cMMeasurementBookDetailEntity.Widthin);
db.AddInParameter(cmd, "@Heightft", DbType.Decimal, cMMeasurementBookDetailEntity.Heightft);
db.AddInParameter(cmd, "@Heightin", DbType.Decimal, cMMeasurementBookDetailEntity.Heightin);
db.AddInParameter(cmd, "@Nos", DbType.Decimal, cMMeasurementBookDetailEntity.Nos);
db.AddInParameter(cmd, "@Qty", DbType.Decimal, cMMeasurementBookDetailEntity.Qty);
db.AddInParameter(cmd, "@Price", DbType.Decimal, cMMeasurementBookDetailEntity.Price);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
returnCode = db.ExecuteNonQuery(cmd, transaction);
returnCode = GetReturnCodeFromParameter(cmd, db);
if (returnCode > 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
private void SaveCMMeasurementBookDetailEntity()
{
if (IsValid)
{
try
{
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = BuildCMMeasurementBookDetailEntity();
Int64 result = -1;
if (cMMeasurementBookDetailEntity.IsNew)
{
result = FCCCMMeasurementBookDetail.GetFacadeCreate().Add(cMMeasurementBookDetailEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookDetailEntity.FLD_NAME_MeasurementBookDetailID, cMMeasurementBookDetailEntity.MeasurementBookDetailID.ToString(), SQLMatchType.Equal);
result = FCCCMMeasurementBookDetail.GetFacadeCreate().Update(cMMeasurementBookDetailEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_MeasurementBookDetailID = 0;
_CMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
PrepareInitialView();
BindCMMeasurementBookDetailList();
if (cMMeasurementBookDetailEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Measurement Book Detail Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Measurement Book Detail Information has been updated successfully.", false);
}
}
else
{
if (cMMeasurementBookDetailEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Measurement Book Detail Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Measurement Book Detail Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private Int64 Update(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.CMMeasurementBookDetail_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@MeasurementBookDetailID", DbType.Int64, cMMeasurementBookDetailEntity.MeasurementBookDetailID);
Database.AddInParameter(cmd, "@MeasurementBookID", DbType.Int64, cMMeasurementBookDetailEntity.MeasurementBookID);
Database.AddInParameter(cmd, "@Description", DbType.String, cMMeasurementBookDetailEntity.Description);
Database.AddInParameter(cmd, "@UnitID", DbType.Int64, cMMeasurementBookDetailEntity.UnitID);
Database.AddInParameter(cmd, "@Lengthft", DbType.Decimal, cMMeasurementBookDetailEntity.Lengthft);
Database.AddInParameter(cmd, "@Lenghtin", DbType.Decimal, cMMeasurementBookDetailEntity.Lenghtin);
Database.AddInParameter(cmd, "@Widthft", DbType.Decimal, cMMeasurementBookDetailEntity.Widthft);
Database.AddInParameter(cmd, "@Widthin", DbType.Decimal, cMMeasurementBookDetailEntity.Widthin);
Database.AddInParameter(cmd, "@Heightft", DbType.Decimal, cMMeasurementBookDetailEntity.Heightft);
Database.AddInParameter(cmd, "@Heightin", DbType.Decimal, cMMeasurementBookDetailEntity.Heightin);
Database.AddInParameter(cmd, "@Nos", DbType.Decimal, cMMeasurementBookDetailEntity.Nos);
Database.AddInParameter(cmd, "@Qty", DbType.Decimal, cMMeasurementBookDetailEntity.Qty);
Database.AddInParameter(cmd, "@Price", DbType.Decimal, cMMeasurementBookDetailEntity.Price);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("CMMeasurementBookDetailEntity already exists. Please specify another CMMeasurementBookDetailEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("CMMeasurementBookDetailEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("CMMeasurementBookDetailEntity already exists. Please specify another CMMeasurementBookDetailEntity.");
}
}
}
}
return(returnCode);
}
private Int64 DeleteTran(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.CMMeasurementBookDetail_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode >= 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
protected void lvCMMeasurementBookDetail_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 MeasurementBookDetailID;
Int64.TryParse(e.CommandArgument.ToString(), out MeasurementBookDetailID);
if (MeasurementBookDetailID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_MeasurementBookDetailID = MeasurementBookDetailID;
PrepareEditView();
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookDetailEntity.FLD_NAME_MeasurementBookDetailID, MeasurementBookDetailID.ToString(), SQLMatchType.Equal);
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
result = FCCCMMeasurementBookDetail.GetFacadeCreate().Delete(cMMeasurementBookDetailEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_MeasurementBookDetailID = 0;
_CMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
PrepareInitialView();
BindCMMeasurementBookDetailList();
MiscUtil.ShowMessage(lblMessage, "Measurement Book Detail has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Measurement Book Detail.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private Int64 Delete(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.CMMeasurementBookDetail_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("CMMeasurementBookDetailEntity already exists. Please specify another CMMeasurementBookDetailEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("CMMeasurementBookDetailEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("CMMeasurementBookDetailEntity already exists. Please specify another CMMeasurementBookDetailEntity.");
}
}
}
}
return(returnCode);
}
Int64 ICMMeasurementBookDetailFacade.Delete(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateCMMeasurementBookDetailDataAccess().Delete(cMMeasurementBookDetailEntity, filterExpression, option, reqTran));
}
Int64 ICMMeasurementBookDetailFacade.Add(CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateCMMeasurementBookDetailDataAccess().Add(cMMeasurementBookDetailEntity, option, reqTran));
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_MeasurementBookDetailID = 0;
_CMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
PrepareInitialView();
}
private CMMeasurementBookDetailEntity BuildCMMeasurementBookDetailEntity()
{
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = CurrentCMMeasurementBookDetailEntity;
cMMeasurementBookDetailEntity.MeasurementBookID = this.CMMeasurementBookID;
cMMeasurementBookDetailEntity.Description = txtDescription.Text.Trim();
if (ddlUnitID.Items.Count > 0)
{
if (ddlUnitID.SelectedValue == "0")
{
}
else
{
cMMeasurementBookDetailEntity.UnitID = Int64.Parse(ddlUnitID.SelectedValue);
}
}
if (!txtLengthft.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Lengthft = Decimal.Parse(txtLengthft.Text.Trim());
}
else
{
cMMeasurementBookDetailEntity.Lengthft = null;
}
if (!txtLenghtin.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Lenghtin = Decimal.Parse(txtLenghtin.Text.Trim());
}
else
{
cMMeasurementBookDetailEntity.Lenghtin = null;
}
if (!txtWidthft.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Widthft = Decimal.Parse(txtWidthft.Text.Trim());
}
else
{
cMMeasurementBookDetailEntity.Widthft = null;
}
if (!txtWidthin.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Widthin = Decimal.Parse(txtWidthin.Text.Trim());
}
else
{
cMMeasurementBookDetailEntity.Widthin = null;
}
if (!txtHeightft.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Heightft = Decimal.Parse(txtHeightft.Text.Trim());
}
else
{
cMMeasurementBookDetailEntity.Heightft = null;
}
if (!txtHeightin.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Heightin = Decimal.Parse(txtHeightin.Text.Trim());
}
else
{
cMMeasurementBookDetailEntity.Heightin = null;
}
if (!txtNos.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Nos = Decimal.Parse(txtNos.Text.Trim());
}
Decimal lenghtft = 1, lengthin = 1, heightft = 1, heightin = 1, widthft = 1, widthin = 1, Qty, Nos;
if (txtLengthft.Text.IsNotNullOrEmpty())
{
Decimal.TryParse(txtLengthft.Text.ToString(), out lenghtft);
}
if (txtLenghtin.Text.IsNotNullOrEmpty())
{
Decimal.TryParse(txtLenghtin.Text.ToString(), out lengthin);
lengthin = Math.Round(lengthin / 12, 2);
}
if (txtWidthft.Text.IsNotNullOrEmpty())
{
Decimal.TryParse(txtWidthft.Text.ToString(), out widthft);
}
if (txtWidthin.Text.IsNotNullOrEmpty())
{
Decimal.TryParse(txtWidthin.Text.ToString(), out widthin);
widthin = Math.Round(widthin / 12, 2);
}
if (txtHeightft.Text.IsNotNullOrEmpty())
{
Decimal.TryParse(txtHeightft.Text.ToString(), out heightft);
}
if (txtHeightin.Text.IsNotNullOrEmpty())
{
Decimal.TryParse(txtHeightin.Text.ToString(), out heightin);
heightin = Math.Round(heightin / 12, 2);
}
Decimal.TryParse(txtNos.Text.ToString(), out Nos);
Qty = (lenghtft + lengthin) * (widthft + widthin) * Nos;
Qty = Math.Round(Qty, 4);
cMMeasurementBookDetailEntity.Qty = Qty;
return(cMMeasurementBookDetailEntity);
}
protected void lvCMMeasurementBookDetail_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 MeasurementBookDetailID;
Int64.TryParse(e.CommandArgument.ToString(), out MeasurementBookDetailID);
if (MeasurementBookDetailID > 0)
{
LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit");
TextBox txtlstDescription = (TextBox)e.Item.FindControl("txtlstDescription");
TextBox txtlstLengthft = (TextBox)e.Item.FindControl("txtlstLengthft");
TextBox txtlstWidthft = (TextBox)e.Item.FindControl("txtlstWidthft");
TextBox txtlstLengthin = (TextBox)e.Item.FindControl("txtlstLengthin");
TextBox txtlstWidthin = (TextBox)e.Item.FindControl("txtlstWidthin");
TextBox txtlstHeightft = (TextBox)e.Item.FindControl("txtlstHeightft");
TextBox txtlstHeightin = (TextBox)e.Item.FindControl("txtlstHeightin");
TextBox txtlstNos = (TextBox)e.Item.FindControl("txtlstNos");
TextBox txtlstQty = (TextBox)e.Item.FindControl("txtlstQty");
DropDownList ddlUnitIDLV = (DropDownList)e.Item.FindControl("ddlUnitIDLV");
if (string.Equals(e.CommandName, "EditItem") && lnkBtnEdit.Text == "Cancel")
{
txtlstDescription.Enabled = false;
txtlstLengthft.Enabled = false;
txtlstWidthft.Enabled = false;
txtlstLengthin.Enabled = false;
txtlstWidthin.Enabled = false;
txtlstHeightft.Enabled = false;
txtlstHeightin.Enabled = false;
txtlstNos.Enabled = false;
ddlUnitIDLV.Enabled = false;
lnkBtnEdit.Text = "Edit";
}
else if (string.Equals(e.CommandName, "EditItem") && lnkBtnEdit.Text == "Edit")
{
_MeasurementBookDetailID = MeasurementBookDetailID;
txtlstDescription.Enabled = true;
txtlstLengthft.Enabled = true;
txtlstWidthft.Enabled = true;
txtlstLengthin.Enabled = true;
txtlstWidthin.Enabled = true;
txtlstHeightft.Enabled = true;
txtlstHeightin.Enabled = true;
txtlstNos.Enabled = true;
ddlUnitIDLV.Enabled = true;
lnkBtnEdit.Text = "Cancel";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookDetailEntity.FLD_NAME_MeasurementBookDetailID, MeasurementBookDetailID.ToString(), SQLMatchType.Equal);
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
result = FCCCMMeasurementBookDetail.GetFacadeCreate().Delete(cMMeasurementBookDetailEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_MeasurementBookDetailID = 0;
_CMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
PrepareInitialView();
BindCMMeasurementBookDetailList();
MiscUtil.ShowMessage(lblMessage, "Measurement Book Detail has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Measurement Book Detail.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
if (string.Equals(e.CommandName, "InsertItem"))
{
SaveCMMeasurementBookDetailEntityLV();
}
}
private void SaveAllCMMeasurementBookDetailListView()
{
UpdateMeasurementBookFloorInfo();
try
{
IList <ListViewDataItem> list = lvCMMeasurementBookDetail.Items;
if (list != null && list.Count > 0)
{
foreach (ListViewDataItem lvdi in list)
{
TextBox txtlstDescription = (TextBox)lvdi.FindControl("txtlstDescription");
if (txtlstDescription.Enabled)
{
Label lbllstMeasurementBookID = (Label)lvdi.FindControl("lbllstMeasurementBookID");
TextBox txtlstLengthft = (TextBox)lvdi.FindControl("txtlstLengthft");
TextBox txtlstLengthin = (TextBox)lvdi.FindControl("txtlstLengthin");
TextBox txtlstWidthft = (TextBox)lvdi.FindControl("txtlstWidthft");
TextBox txtlstWidthin = (TextBox)lvdi.FindControl("txtlstWidthin");
TextBox txtlstHeightft = (TextBox)lvdi.FindControl("txtlstHeightft");
TextBox txtlstHeightin = (TextBox)lvdi.FindControl("txtlstHeightin");
TextBox txtlstNos = (TextBox)lvdi.FindControl("txtlstNos");
TextBox txtlstQty = (TextBox)lvdi.FindControl("txtlstQty");
DropDownList ddlUnitIDLV = (DropDownList)lvdi.FindControl("ddlUnitIDLV");
Decimal LengthftLV, LengthinLV, WidthftLV, WidthinLV, HeightftLV, HeightinLV, NosLV;
Decimal.TryParse(txtlstLengthft.Text.Trim(), out LengthftLV);
Decimal.TryParse(txtlstLengthin.Text.Trim(), out LengthinLV);
Decimal.TryParse(txtlstWidthft.Text.Trim(), out WidthftLV);
Decimal.TryParse(txtlstWidthin.Text.Trim(), out WidthinLV);
Decimal.TryParse(txtlstHeightft.Text.Trim(), out HeightftLV);
Decimal.TryParse(txtlstHeightin.Text.Trim(), out HeightinLV);
Decimal.TryParse(txtlstNos.Text.Trim(), out NosLV);
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
cMMeasurementBookDetailEntity.Description = txtlstDescription.Text.ToString();
cMMeasurementBookDetailEntity.Lengthft = LengthftLV;
cMMeasurementBookDetailEntity.Lenghtin = LengthinLV;
cMMeasurementBookDetailEntity.Widthft = WidthftLV;
cMMeasurementBookDetailEntity.Widthin = WidthinLV;
cMMeasurementBookDetailEntity.Heightft = HeightftLV;
cMMeasurementBookDetailEntity.Heightin = HeightinLV;
cMMeasurementBookDetailEntity.MeasurementBookID = CMMeasurementBookID;
LengthinLV = Math.Round(LengthinLV / 12, 2);
WidthinLV = Math.Round(WidthinLV / 12, 2);
HeightinLV = Math.Round(HeightinLV / 12, 2);
Decimal QtyLV;
QtyLV = (LengthftLV + LengthinLV) * (WidthftLV + WidthinLV) * NosLV;
QtyLV = Math.Round(QtyLV, 4);
if (ddlUnitIDLV != null && ddlUnitIDLV.SelectedValue != "0")
{
cMMeasurementBookDetailEntity.UnitID = Int64.Parse(ddlUnitIDLV.SelectedValue.ToString());
}
cMMeasurementBookDetailEntity.Nos = NosLV;
cMMeasurementBookDetailEntity.Qty = QtyLV;
String fe = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookDetailEntity.FLD_NAME_MeasurementBookDetailID, lbllstMeasurementBookID.Text.ToString(), SQLMatchType.Equal);
FCCCMMeasurementBookDetail.GetFacadeCreate().Update(cMMeasurementBookDetailEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
}
}
}
BindCMMeasurementBookDetailList();
MiscUtil.ShowMessage(lblMessage, "Measurement Book Detail Information has been saved successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Failed to save Measurment Book Detail Information.", true);
}
}
private void SaveCMMeasurementBookDetailEntityLV()
{
try
{
UpdateMeasurementBookFloorInfo();
ListViewItem list = lvCMMeasurementBookDetail.InsertItem;
TextBox txtDescriptionLV = (TextBox)list.FindControl("txtDescriptionLV");
TextBox txtLengthftLV = (TextBox)list.FindControl("txtLengthftLV");
TextBox txtLenghtinLV = (TextBox)list.FindControl("txtLenghtinLV");
TextBox txtWidthinLV = (TextBox)list.FindControl("txtWidthinLV");
TextBox txtWidthftLV = (TextBox)list.FindControl("txtWidthftLV");
TextBox txtHeightftLV = (TextBox)list.FindControl("txtHeightftLV");
TextBox txtHeightinLV = (TextBox)list.FindControl("txtHeightinLV");
TextBox txtNosLV = (TextBox)list.FindControl("txtNosLV");
DropDownList ddlUnitIDInsert = (DropDownList)list.FindControl("ddlUnitIDInsert");
Decimal LengthftLV, LengthinLV, WidthftLV, WidthinLV, HeightftLV, HeightinLV, NosLV;
Decimal.TryParse(txtLengthftLV.Text.Trim(), out LengthftLV);
Decimal.TryParse(txtLenghtinLV.Text.Trim(), out LengthinLV);
Decimal.TryParse(txtWidthinLV.Text.Trim(), out WidthftLV);
Decimal.TryParse(txtWidthftLV.Text.Trim(), out WidthinLV);
Decimal.TryParse(txtHeightftLV.Text.Trim(), out HeightftLV);
Decimal.TryParse(txtHeightinLV.Text.Trim(), out HeightinLV);
Decimal.TryParse(txtNosLV.Text.Trim(), out NosLV);
CMMeasurementBookDetailEntity cMMeasurementBookDetailEntity = new CMMeasurementBookDetailEntity();
cMMeasurementBookDetailEntity.Description = txtDescriptionLV.Text.ToString();
if (!txtLengthftLV.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Lengthft = LengthftLV;
}
else
{
cMMeasurementBookDetailEntity.Lengthft = null;
}
if (!txtLenghtinLV.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Lenghtin = LengthinLV;
}
else
{
cMMeasurementBookDetailEntity.Lenghtin = null;
}
if (!txtWidthftLV.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Widthft = WidthftLV;
}
else
{
cMMeasurementBookDetailEntity.Widthft = null;
}
if (!txtWidthinLV.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Widthin = WidthinLV;
}
else
{
cMMeasurementBookDetailEntity.Widthin = null;
}
if (!txtHeightftLV.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Heightft = HeightftLV;
}
else
{
cMMeasurementBookDetailEntity.Heightft = null;
}
if (!txtHeightinLV.Text.Trim().IsNullOrEmpty())
{
cMMeasurementBookDetailEntity.Heightin = HeightinLV;
}
else
{
cMMeasurementBookDetailEntity.Heightin = null;
}
cMMeasurementBookDetailEntity.MeasurementBookID = CMMeasurementBookID;
LengthinLV = Math.Round(LengthinLV / 12, 2);
WidthinLV = Math.Round(WidthinLV / 12, 2);
HeightinLV = Math.Round(HeightinLV / 12, 2);
Decimal QtyLV;
QtyLV = (LengthftLV + LengthinLV) * (WidthftLV + WidthinLV) * NosLV;
QtyLV = Math.Round(QtyLV, 4);
cMMeasurementBookDetailEntity.UnitID = Int64.Parse(ddlUnitIDInsert.SelectedValue.ToString());
cMMeasurementBookDetailEntity.Nos = NosLV;
cMMeasurementBookDetailEntity.Qty = QtyLV;
Int64 result = -1;
result = FCCCMMeasurementBookDetail.GetFacadeCreate().Add(cMMeasurementBookDetailEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "Measurement Book Detail Information has been saved successfully.", false);
BindCMMeasurementBookDetailList();
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Failed to save Measurement Book Detail Information.", true);
}
}
