Int64 ICRMAgreementSpecsDataAccess.Add(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(cRMAgreementSpecsEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(cRMAgreementSpecsEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 Update(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementSpecs_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@AgreementSpecsID", DbType.Int64, cRMAgreementSpecsEntity.AgreementSpecsID); Database.AddInParameter(cmd, "@AgreementID", DbType.Int64, cRMAgreementSpecsEntity.AgreementID); Database.AddInParameter(cmd, "@Item", DbType.String, cRMAgreementSpecsEntity.Item); Database.AddInParameter(cmd, "@BrandID", DbType.Int64, cRMAgreementSpecsEntity.BrandID); Database.AddInParameter(cmd, "@BayQty", DbType.Decimal, cRMAgreementSpecsEntity.BayQty); Database.AddInParameter(cmd, "@BayPrice", DbType.Decimal, cRMAgreementSpecsEntity.BayPrice); Database.AddInParameter(cmd, "@CustomerQty", DbType.Decimal, cRMAgreementSpecsEntity.CustomerQty); Database.AddInParameter(cmd, "@CustomerPrice", DbType.Decimal, cRMAgreementSpecsEntity.CustomerPrice); Database.AddInParameter(cmd, "@Field1", DbType.String, cRMAgreementSpecsEntity.Field1); Database.AddInParameter(cmd, "@Field2", DbType.String, cRMAgreementSpecsEntity.Field2); Database.AddInParameter(cmd, "@var0", DbType.String, cRMAgreementSpecsEntity.var0); Database.AddInParameter(cmd, "@var1", DbType.String, cRMAgreementSpecsEntity.var1); Database.AddInParameter(cmd, "@var2", DbType.String, cRMAgreementSpecsEntity.var2); Database.AddInParameter(cmd, "@var3", DbType.String, cRMAgreementSpecsEntity.var3); Database.AddInParameter(cmd, "@var4", DbType.String, cRMAgreementSpecsEntity.var4); Database.AddInParameter(cmd, "@var5", DbType.String, cRMAgreementSpecsEntity.var5); Database.AddInParameter(cmd, "@Remarks", DbType.String, cRMAgreementSpecsEntity.Remarks); Database.AddInParameter(cmd, "@AgreementSpecsType", DbType.String, cRMAgreementSpecsEntity.AgreementSpecsType); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CRMAgreementSpecsEntity already exists. Please specify another CRMAgreementSpecsEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CRMAgreementSpecsEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CRMAgreementSpecsEntity already exists. Please specify another CRMAgreementSpecsEntity."); } } } } return(returnCode); }
private Int64 DeleteTran(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementSpecs_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 lvCRMAgreementSpecs_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 AgreementSpecsID; Int64.TryParse(e.CommandArgument.ToString(), out AgreementSpecsID); if (AgreementSpecsID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _AgreementSpecsID = AgreementSpecsID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementSpecsEntity.FLD_NAME_AgreementSpecsID, AgreementSpecsID.ToString(), SQLMatchType.Equal); CRMAgreementSpecsEntity cRMAgreementSpecsEntity = new CRMAgreementSpecsEntity(); result = FCCCRMAgreementSpecs.GetFacadeCreate().Delete(cRMAgreementSpecsEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _AgreementSpecsID = 0; _CRMAgreementSpecsEntity = new CRMAgreementSpecsEntity(); PrepareInitialView(); BindCRMAgreementSpecsList(); MiscUtil.ShowMessage(lblMessage, "C RMAgreement Specs has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete C RMAgreement Specs.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 Delete(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementSpecs_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("CRMAgreementSpecsEntity already exists. Please specify another CRMAgreementSpecsEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CRMAgreementSpecsEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CRMAgreementSpecsEntity already exists. Please specify another CRMAgreementSpecsEntity."); } } } } return(returnCode); }
private void PrepareEditView() { CRMAgreementSpecsEntity cRMAgreementSpecsEntity = CurrentCRMAgreementSpecsEntity; if (!cRMAgreementSpecsEntity.IsNew) { txtItemName.Text = cRMAgreementSpecsEntity.Item.ToString(); if (ddlBrandID.Items.Count > 0 && cRMAgreementSpecsEntity.BrandID != null) { ddlBrandID.SelectedValue = cRMAgreementSpecsEntity.BrandID.ToString(); } if (ddlUnitID.Items.Count > 0 && cRMAgreementSpecsEntity.Field1 != null) { // ddlUnitID.Text = cRMAgreementSpecsEntity.Field1; } txtBayQty.Text = cRMAgreementSpecsEntity.BayQty.ToString(); txtBayPrice.Text = cRMAgreementSpecsEntity.BayPrice.ToString(); txtCustomerQty.Text = cRMAgreementSpecsEntity.CustomerQty.ToString(); txtCustomerPrice.Text = cRMAgreementSpecsEntity.CustomerPrice.ToString(); txtField2.Text = cRMAgreementSpecsEntity.Field2.ToString(); txtvar0.Text = cRMAgreementSpecsEntity.var0.ToString(); txtvar1.Text = cRMAgreementSpecsEntity.var1.ToString(); txtvar2.Text = cRMAgreementSpecsEntity.var2.ToString(); txtvar3.Text = cRMAgreementSpecsEntity.var3.ToString(); txtvar4.Text = cRMAgreementSpecsEntity.var4.ToString(); txtvar5.Text = cRMAgreementSpecsEntity.var5.ToString(); txtRemarks.Text = cRMAgreementSpecsEntity.Remarks.ToString(); txtAgreementSpecsType.Text = cRMAgreementSpecsEntity.AgreementSpecsType.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
Int64 ICRMAgreementSpecsFacade.Delete(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCRMAgreementSpecsDataAccess().Delete(cRMAgreementSpecsEntity, filterExpression, option, reqTran)); }
Int64 ICRMAgreementSpecsFacade.Add(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCRMAgreementSpecsDataAccess().Add(cRMAgreementSpecsEntity, option, reqTran)); }
private Int64 UpdateTran(CRMAgreementSpecsEntity cRMAgreementSpecsEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementSpecs_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@AgreementSpecsID", DbType.Int64, cRMAgreementSpecsEntity.AgreementSpecsID); db.AddInParameter(cmd, "@AgreementID", DbType.Int64, cRMAgreementSpecsEntity.AgreementID); db.AddInParameter(cmd, "@Item", DbType.String, cRMAgreementSpecsEntity.Item); db.AddInParameter(cmd, "@BrandID", DbType.Int64, cRMAgreementSpecsEntity.BrandID); db.AddInParameter(cmd, "@BayQty", DbType.Decimal, cRMAgreementSpecsEntity.BayQty); db.AddInParameter(cmd, "@BayPrice", DbType.Decimal, cRMAgreementSpecsEntity.BayPrice); db.AddInParameter(cmd, "@CustomerQty", DbType.Decimal, cRMAgreementSpecsEntity.CustomerQty); db.AddInParameter(cmd, "@CustomerPrice", DbType.Decimal, cRMAgreementSpecsEntity.CustomerPrice); db.AddInParameter(cmd, "@Field1", DbType.String, cRMAgreementSpecsEntity.Field1); db.AddInParameter(cmd, "@Field2", DbType.String, cRMAgreementSpecsEntity.Field2); db.AddInParameter(cmd, "@var0", DbType.String, cRMAgreementSpecsEntity.var0); db.AddInParameter(cmd, "@var1", DbType.String, cRMAgreementSpecsEntity.var1); db.AddInParameter(cmd, "@var2", DbType.String, cRMAgreementSpecsEntity.var2); db.AddInParameter(cmd, "@var3", DbType.String, cRMAgreementSpecsEntity.var3); db.AddInParameter(cmd, "@var4", DbType.String, cRMAgreementSpecsEntity.var4); db.AddInParameter(cmd, "@var5", DbType.String, cRMAgreementSpecsEntity.var5); db.AddInParameter(cmd, "@Remarks", DbType.String, cRMAgreementSpecsEntity.Remarks); db.AddInParameter(cmd, "@AgreementSpecsType", DbType.String, cRMAgreementSpecsEntity.AgreementSpecsType); 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 btnAddNew_Click(object sender, EventArgs e) { _AgreementSpecsID = 0; _CRMAgreementSpecsEntity = new CRMAgreementSpecsEntity(); PrepareInitialView(); }
private void SaveCRMAgreementSpecsEntity() { if (IsValid) { try { CRMAgreementSpecsEntity cRMAgreementSpecsEntity = BuildCRMAgreementSpecsEntity(); Int64 result = -1; if (cRMAgreementSpecsEntity.IsNew) { result = FCCCRMAgreementSpecs.GetFacadeCreate().Add(cRMAgreementSpecsEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementSpecsEntity.FLD_NAME_AgreementSpecsID, cRMAgreementSpecsEntity.AgreementSpecsID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreementSpecs.GetFacadeCreate().Update(cRMAgreementSpecsEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { if (cRMAgreementSpecsEntity.IsNew) { for (Int32 i = 1; i <= 5; i++) { CRMAgreementVariableMapEntity ent = new CRMAgreementVariableMapEntity(); switch (i) { //case 1: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType+"_"+cRMAgreementSpecsEntity.Item +"_IName"+ result.ToString() + "%>"; // ent.Value = cRMAgreementSpecsEntity.Item; // break; //case 2: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + ddlBrandID.SelectedItem + "_IBrand_" + result.ToString() + "%>"; // ent.Value = ddlBrandID.SelectedItem.ToString(); // break; //case 3: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Item+"_IQty_"+ result.ToString()+ "%>"; // ent.Value = cRMAgreementSpecsEntity.BayQty.ToString(); // break; //case 4: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Item+"_IPrice_"+ result.ToString()+"%>"; // ent.Value = cRMAgreementSpecsEntity.BayPrice.ToString(); // break; //case 5: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Field1+ "_IUnit_"+ result.ToString() + "%>"; // ent.Value = cRMAgreementSpecsEntity.Field1.ToString(); // break; case 1: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IName" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.Item; break; case 2: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IBrand_" + result.ToString() + "%>"; ent.Value = ddlBrandID.SelectedItem.ToString(); break; case 3: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IQty_" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.BayQty.ToString(); break; case 4: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IPrice_" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.BayPrice.ToString(); break; case 5: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IUnit_" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.Field1.ToString(); break; } ent.CreateDate = System.DateTime.Now; ent.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); ent.IP = MiscUtil.GetLocalIP(); ent.Remarks = "Auto Generated"; ent.AgreementID = OverviewAgreementID; FCCCRMAgreementVariableMap.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } _AgreementSpecsID = 0; _CRMAgreementSpecsEntity = new CRMAgreementSpecsEntity(); PrepareInitialView(); BindCRMAgreementSpecsList(); if (cRMAgreementSpecsEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Agreement Specs Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Agreement Specs Information has been updated successfully.", false); } } else { if (cRMAgreementSpecsEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Agreement Specs Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Agreement Specs Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private CRMAgreementSpecsEntity BuildCRMAgreementSpecsEntity() { CRMAgreementSpecsEntity cRMAgreementSpecsEntity = CurrentCRMAgreementSpecsEntity; cRMAgreementSpecsEntity.AgreementID = OverviewAgreementID; cRMAgreementSpecsEntity.Item = txtItemName.Text.Trim(); if (ddlBrandID.Items.Count > 0) { if (ddlBrandID.SelectedValue == "0") { } else { cRMAgreementSpecsEntity.BrandID = Int64.Parse(ddlBrandID.SelectedValue); } } if (!txtBayQty.Text.Trim().IsNullOrEmpty()) { cRMAgreementSpecsEntity.BayQty = Decimal.Parse(txtBayQty.Text.Trim()); } else { cRMAgreementSpecsEntity.BayQty = null; } if (!txtBayPrice.Text.Trim().IsNullOrEmpty()) { cRMAgreementSpecsEntity.BayPrice = Decimal.Parse(txtBayPrice.Text.Trim()); } else { cRMAgreementSpecsEntity.BayPrice = null; } if (!txtCustomerQty.Text.Trim().IsNullOrEmpty()) { cRMAgreementSpecsEntity.CustomerQty = Decimal.Parse(txtCustomerQty.Text.Trim()); } else { cRMAgreementSpecsEntity.CustomerQty = null; } if (!txtCustomerPrice.Text.Trim().IsNullOrEmpty()) { cRMAgreementSpecsEntity.CustomerPrice = Decimal.Parse(txtCustomerPrice.Text.Trim()); } else { cRMAgreementSpecsEntity.CustomerPrice = null; } if (ddlUnitID.Items.Count > 0) { if (ddlUnitID.SelectedValue == "0") { } else { cRMAgreementSpecsEntity.Field1 = ddlUnitID.SelectedItem.ToString(); } } cRMAgreementSpecsEntity.Field2 = txtField2.Text.Trim(); cRMAgreementSpecsEntity.var0 = txtvar0.Text.Trim(); cRMAgreementSpecsEntity.var1 = txtvar1.Text.Trim(); cRMAgreementSpecsEntity.var2 = txtvar2.Text.Trim(); cRMAgreementSpecsEntity.var3 = txtvar3.Text.Trim(); cRMAgreementSpecsEntity.var4 = txtvar4.Text.Trim(); cRMAgreementSpecsEntity.var5 = txtvar5.Text.Trim(); cRMAgreementSpecsEntity.Remarks = txtRemarks.Text.Trim(); cRMAgreementSpecsEntity.AgreementSpecsType = txtAgreementSpecsType.Text.Trim(); return(cRMAgreementSpecsEntity); }