protected void saveButton_Click(object sender, EventArgs e) { try { UnitUser userObj = new UnitUser(); UnitHolderRegistration regObj = new UnitHolderRegistration(); userObj.UserID = UserIDTextBox.Text.Trim().ToString(); userObj.UserPassword = encrypt.Encrypt(oldPasswordTextBox.Text.Trim().ToString()); userObj.UserChangePassword = encrypt.Encrypt(confirmPasswordTextBox.Text.Trim().ToString()); if (string.Compare((string)Session["UserID"].ToString().ToUpper(), UserIDTextBox.Text.Trim().ToString().ToUpper()) == 0 || string.Compare("ADMIN", (string)Session["UserID"].ToString().ToUpper()) == 0) { if (!userBLObj.CheckExistUser(userObj)) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('Password Change Failed: Invalid User ID or Password');", true); } else { userBLObj.updateUserPassword(userObj); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "window.fnReset();alert ('Password Changed Successfully');", true); // ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Created Successfully');", true); } } else { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('You have no permission to change password for this User');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed:" + ex.Message.Replace("'", "").ToString() + "');", true); } }
public static UnitUser GetUnit(string userName) { string sql = string.Format("select * from unit where phone = '{0}' or userName='******'", userName, userName); DataTable dt = new DataTable(); dt = MySqlHelper.mySqlExecuteQuery(sql, null, false); UnitUser unit = new UnitUser(); if (dt.Rows.Count > 0) { unit.UnitId = dt.Rows[0]["Id"].ToString(); unit.UnitName = dt.Rows[0]["UnitName"].ToString(); unit.Phone = dt.Rows[0]["Phone"].ToString(); unit.BeginDate = dt.Rows[0]["BeginDate"].ToString(); unit.EndDate = dt.Rows[0]["EndDate"].ToString(); unit.PassWord = dt.Rows[0]["PassWord"].ToString(); unit.Linkman = dt.Rows[0]["Linkman"].ToString(); unit.UserName = dt.Rows[0]["UserName"].ToString(); return(unit); } else { return(null); } }
public void AttachUnitToUser(int unitId, int userId) { var unitUsers = unitOfWork.DbContext.Set<UnitUser>(); var unitUser = new UnitUser { UnitId = unitId, UserId = userId, IsActive = true }; unitUsers.Add(unitUser); unitOfWork.Save(); }
protected void saveButton_Click(object sender, EventArgs e) { try { DataTable dtUserMenu = new DataTable(); dtUserMenu.Columns.Add("M_ID", typeof(string)); DataRow drUserMenu = dtUserMenu.NewRow(); UnitUser userObj = new UnitUser(); UnitHolderRegistration regObj = new UnitHolderRegistration(); userObj.UserID = UserIDTextBox.Text.Trim().ToString(); userObj.UserPassword = encrypt.Encrypt(passwordTextBox.Text.Trim().ToString()); userObj.UserName = userNameTextBox.Text.Trim().ToString().ToUpper(); regObj.FundCode = fundNameDropDownList.SelectedValue.ToString(); regObj.BranchCode = branchNameDropDownList.SelectedValue.ToString(); if (menuCheckBoxList.Items.Count > 0) { for (int loop = 0; loop < menuCheckBoxList.Items.Count; loop++) { if (menuCheckBoxList.Items[loop].Selected) { drUserMenu = dtUserMenu.NewRow(); drUserMenu["M_ID"] = menuCheckBoxList.Items[loop].Value.ToString(); dtUserMenu.Rows.Add(drUserMenu); } } } if (dtUserMenu.Rows.Count > 0) { if (userBLObj.CheckDuplicate(regObj, userObj)) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed: Duplicate User ID');", true); } else { // userBLObj.saveUser(regObj, userObj, dtUserMenu); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "window.fnReset();alert ('User Created Successfully');", true); // ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Created Successfully');", true); } } else { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed: No Menu is Checked');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed:" + ex.Message.Replace("'", "").ToString() + "');", true); } }
protected void OkButton_Click(object sender, EventArgs e) { BaseClass bcContent = new BaseClass(); UnitUser userObj = new UnitUser(); UnitHolderRegistration regObj = new UnitHolderRegistration(); userObj.UserID = (string)Session["UserID"].ToString(); //userObj.UserPassword = (string)Session["UserPassword"].ToString(); regObj.FundCode = fundNameDropDownList.SelectedValue.ToString(); regObj.BranchCode = branchNameDropDownList.SelectedValue.ToString(); bool userLevelPermission = false; if (userObj.UserID.ToUpper().ToString() == "ADMIN") { userLevelPermission = true; } else { if (userBLObj.GetUserBranchPermission(regObj, userObj) && userBLObj.GetUserFundPermission(regObj, userObj)) { userLevelPermission = true; } else { userLevelPermission = false; } } if (userLevelPermission) { bcContent.LoginID = (string)Session["UserID"]; bcContent.LoginUserName = (string)Session["UserName"]; bcContent.LoginTime = DateTime.Now; bcContent.Roles = (string)Session["UseRole"]; bcContent.BranchCode = branchNameDropDownList.SelectedValue.ToString(); bcContent.FundCode = fundNameDropDownList.SelectedValue.ToString(); bcContent.CDS = opendMFDAO.getCDSStatus(fundNameDropDownList.SelectedValue.ToString()); bcContent.AppId = 1; bcContent.DbServerType = "C"; long loginSessionID = logDAO.Login(bcContent); bcContent.SessionID = loginSessionID; Session["BCContent"] = bcContent; Response.Redirect("UnitHome.aspx"); } else { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('You Have No Permission to Enter This Branch or Fund');", true); } }
public string GetNextSaleType(UnitHolderRegistration regObj, UnitUser unitUserObj) { string saleType = "SL"; DataTable dtNextSaleType = new DataTable(); dtNextSaleType = commonGatewayObj.Select("SELECT SL_TYPE FROM SALE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "' AND ENT_DT IN(SELECT MAX(ENT_DT) FROM SALE SALE_1 WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "' )"); if (dtNextSaleType.Rows.Count > 0) { if (!dtNextSaleType.Rows[0]["SL_TYPE"].Equals(DBNull.Value)) { saleType = dtNextSaleType.Rows[0]["SL_TYPE"].ToString(); } } return(saleType); }
public int getNextMoneReceiptNo(UnitHolderRegistration regObj, UnitUser unitUserObj) { int nextMoneReceiptNo = 0; DataTable dtNextMoneReceiptNo = new DataTable(); dtNextMoneReceiptNo = commonGatewayObj.Select("SELECT MAX(MONY_RECT_NO) AS MAX_MONEY_NO FROM SALE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "' AND ENT_DT IN(SELECT MAX(ENT_DT) FROM SALE SALE_1 WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "' )"); if (!dtNextMoneReceiptNo.Rows[0]["MAX_MONEY_NO"].Equals(DBNull.Value)) { nextMoneReceiptNo = Convert.ToInt16(dtNextMoneReceiptNo.Rows[0]["MAX_MONEY_NO"].ToString()); } else { dtNextMoneReceiptNo = new DataTable(); dtNextMoneReceiptNo = commonGatewayObj.Select("SELECT MAX(MONY_RECT_NO) AS MAX_MONEY_NO FROM SALE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "'"); nextMoneReceiptNo = dtNextMoneReceiptNo.Rows[0]["MAX_MONEY_NO"].Equals(DBNull.Value) ? 0 : Convert.ToInt16(dtNextMoneReceiptNo.Rows[0]["MAX_MONEY_NO"].ToString()); } return(nextMoneReceiptNo + 1); }
public int getNextRepurchaseNo(UnitHolderRegistration regObj, UnitUser unitUserObj) { int nextRepurchaseNo = 0; DataTable dtNextRepurchaseNo = new DataTable(); dtNextRepurchaseNo = commonGatewayObj.Select("SELECT MAX(REP_NO) AS REP_NO FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "'"); if (!dtNextRepurchaseNo.Rows[0]["REP_NO"].Equals(DBNull.Value)) { nextRepurchaseNo = Convert.ToInt16(dtNextRepurchaseNo.Rows[0]["REP_NO"].ToString()); } else { dtNextRepurchaseNo = new DataTable(); dtNextRepurchaseNo = commonGatewayObj.Select("SELECT MAX(REP_NO) AS REP_NO FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'"); nextRepurchaseNo = dtNextRepurchaseNo.Rows[0]["REP_NO"].Equals(DBNull.Value) ? 0 : Convert.ToInt16(dtNextRepurchaseNo.Rows[0]["REP_NO"].ToString()); } return(nextRepurchaseNo + 1); }
public int getNextLienCancelNo(UnitHolderRegistration regObj, UnitUser unitUserObj) { int nextLienNo = 0; DataTable dtNextLienNo = new DataTable(); dtNextLienNo = commonGatewayObj.Select("SELECT MAX(TO_NUMBER(LIEN_CANCL_NO)) AS LIEN_CANCL_NO FROM LIEN_MARK_CANCEL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "'"); if (!dtNextLienNo.Rows[0]["LIEN_CANCL_NO"].Equals(DBNull.Value)) { nextLienNo = Convert.ToInt32(dtNextLienNo.Rows[0]["LIEN_CANCL_NO"].ToString()); } else { dtNextLienNo = new DataTable(); dtNextLienNo = commonGatewayObj.Select("SELECT MAX(TO_NUMBER(LIEN_CANCL_NO)) AS LIEN_CANCL_NO FROM LIEN_MARK_CANCEL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'"); nextLienNo = dtNextLienNo.Rows[0]["LIEN_CANCL_NO"].Equals(DBNull.Value) ? 0 : Convert.ToInt32(dtNextLienNo.Rows[0]["LIEN_CANCL_NO"].ToString()); } return(nextLienNo + 1); }
public int getNextTransferNo(UnitHolderRegistration regObj, UnitUser unitUserObj) { int nextTransferNo = 0; DataTable dtNextTransferNo = new DataTable(); dtNextTransferNo = commonGatewayObj.Select("SELECT MAX(TR_NO) AS MAX_TR_NO FROM TRANSFER WHERE F_CD='" + regObj.FundCode.ToString().ToUpper() + "'AND BR_CODE='" + regObj.FundCode.ToString().ToUpper() + "_" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "'"); if (!dtNextTransferNo.Rows[0]["MAX_TR_NO"].Equals(DBNull.Value)) { nextTransferNo = Convert.ToInt16(dtNextTransferNo.Rows[0]["MAX_TR_NO"].ToString()); } else { dtNextTransferNo = new DataTable(); dtNextTransferNo = commonGatewayObj.Select("SELECT MAX(TR_NO) AS MAX_TR_NO FROM TRANSFER WHERE F_CD='" + regObj.FundCode.ToString().ToUpper() + "'AND BR_CODE='" + regObj.FundCode.ToString().ToUpper() + "_" + regObj.BranchCode.ToString() + "'"); nextTransferNo = dtNextTransferNo.Rows[0]["MAX_TR_NO"].Equals(DBNull.Value) ? 0 : Convert.ToInt16(dtNextTransferNo.Rows[0]["MAX_TR_NO"].ToString()); } return(nextTransferNo + 1); }
public int getNextRenNo(UnitHolderRegistration regObj, UnitUser unitUserObj) { int nextSaleNo = 0; DataTable dtNextSaleNo = new DataTable(); dtNextSaleNo = commonGatewayObj.Select("SELECT REN_NO AS MAX_SL_NO FROM RENEWAL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "' AND ENT_DT IN (SELECT MAX(ENT_DT) FROM RENEWAL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND USER_NM='" + unitUserObj.UserID.ToString() + "')"); if (dtNextSaleNo.Rows.Count > 0) { nextSaleNo = Convert.ToInt16(dtNextSaleNo.Rows[0]["MAX_SL_NO"].ToString()); } else { dtNextSaleNo = new DataTable(); dtNextSaleNo = commonGatewayObj.Select("SELECT REN_NO AS MAX_SL_NO FROM RENEWAL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND ENT_DT IN (SELECT MAX(ENT_DT) FROM RENEWAL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "')"); if (dtNextSaleNo.Rows.Count > 0) { nextSaleNo = dtNextSaleNo.Rows[0]["MAX_SL_NO"].Equals(DBNull.Value) ? 0 : Convert.ToInt16(dtNextSaleNo.Rows[0]["MAX_SL_NO"].ToString()); } } return(nextSaleNo + 1); }
public UnitUserDO(UnitUser u) : this() { if (u != null) { this.UnitUserId = u.UnitUserId; this.UserId = u.UserId; this.UnitId = u.UnitId; this.IsActive = u.IsActive; this.Version = u.Version; if (u.User != null) { this.Username = u.User.Username; } if (u.Unit != null) { this.UnitName = u.Unit.Name; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserID"] == null) { Session.RemoveAll(); Response.Redirect("../Default.aspx"); } if (!IsPostBack) { UnitUser userObj = new UnitUser(); userObj.UserID = (string)Session["UserID"].ToString(); fundNameDropDownList.DataSource = opendMFDAO.dtFundList(userObj); fundNameDropDownList.DataTextField = "FUND_NM"; fundNameDropDownList.DataValueField = "FUND_CD"; fundNameDropDownList.DataBind(); branchNameDropDownList.DataSource = opendMFDAO.dtBranchList(userObj); branchNameDropDownList.DataTextField = "BR_NM"; branchNameDropDownList.DataValueField = "BR_CD"; branchNameDropDownList.DataBind(); } }
public static UnitUser GetInnerUser(string userName) { string sql = string.Format("select * from ServiceUser where userloginname = '{0}'", userName); DataTable dt = new DataTable(); dt = MySqlHelper.mySqlExecuteQuery(sql, null, false); UnitUser unit = new UnitUser(); if (dt.Rows.Count > 0) { unit.UnitId = dt.Rows[0]["UserID"].ToString(); unit.UnitName = dt.Rows[0]["UserName"].ToString(); unit.Phone = ""; unit.BeginDate = ""; unit.EndDate = ""; unit.PassWord = dt.Rows[0]["UserPassword"].ToString(); unit.Linkman = ""; return(unit); } else { return(null); } }
public DocListItemDO(Docs.Api.Models.Doc d, UnitUser unitUser = null) : this() { if (d != null) { this.DocId = d.DocId; this.RegDate = d.RegDate; this.RegUri = d.RegUri; this.DocSubject = d.DocSubject; if (d.DocStatus != null) { this.DocStatusName = d.GetDocStatusName(); } if (d.DocType != null) { this.DocTypeName = d.DocType.Name; } if (d.DocDirection != null) { this.DocDirectionName = d.DocDirection.Name; } if (d.DocHasReads != null && d.DocHasReads.Any()) { this.IsRead = d.DocHasReads.Any(e => e.HasRead); } if (d.DocSourceType != null) { this.IsElectronic = d.DocSourceType.Alias == "Internet"; } } }
public void saveTransfer(DataTable dtTransferSaleCert, UnitHolderRegistration regObj, UnitTransfer transferObj, UnitUser unitUserObj) { try { commonGatewayObj.BeginTransaction(); Hashtable htTransferRegInfo = new Hashtable(); Hashtable htTransCertNoTemp = new Hashtable(); int SL_TR_RN = 0; int CertNo = 0; string certType = ""; string[] saleNoArray; string[] certArray; string statusFlag = "T"; string Old_SL_TR_RN = ""; for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++) { if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0) { htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_NO", transferObj.TransfereeRegNo.ToString()); htTransferRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString()); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('S'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htTransferRegInfo, "SALE_CERT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "S" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('T') >= 0) { htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString()); htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_NO", transferObj.TransfereeRegNo.ToString()); htTransferRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString()); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('T'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htTransferRegInfo, "TRANS_CERT", "F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND TR_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); commonGatewayObj.Update(htTransferRegInfo, "SALE_CERT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); commonGatewayObj.Update(htTransferRegInfo, "RENEWAL_OUT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "T" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0) { htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_NO", transferObj.TransfereeRegNo.ToString()); htTransferRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString()); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('R'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htTransferRegInfo, "RENEWAL_OUT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "R" + SL_TR_RN.ToString(); } htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("F_CD", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString())); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); htTransferRegInfo.Add("CERT_TYPE", certArray[0].ToString().ToUpper()); htTransferRegInfo.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString())); htTransferRegInfo.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper()); htTransferRegInfo.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString())); htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("CURR_REG_NO", Convert.ToInt32(transferObj.TransfereeRegNo.ToString())); htTransferRegInfo.Add("OLD_SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper()); commonGatewayObj.Insert(htTransferRegInfo, "TRANS_CERT"); } DataTable dtTransfer = dtTrnasfer(dtTransferSaleCert); for (int i = 0; i < dtTransfer.Rows.Count; i++) { //htTransCertNoTemp = new Hashtable(); //htTransCertNoTemp.Add("F_CD", regObj.FundCode.ToString().ToUpper()); //htTransCertNoTemp.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper()); //htTransCertNoTemp.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString())); //htTransCertNoTemp.Add("CERTIFICATE", dtTransfer.Rows[i]["CERTIFICATE"].ToString()); //htTransCertNoTemp.Add("OLD_SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString()); // commonGatewayObj.Insert(htTransCertNoTemp, "TRANS_CERT_NO_TEMP"); htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("F_CD", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString())); htTransferRegInfo.Add("TR_DT", Convert.ToDateTime(transferObj.TransferDate.ToString()).ToString("dd-MMM-yyyy")); htTransferRegInfo.Add("REG_BK_O", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_BR_O", transferObj.TferorBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_NO_O", Convert.ToInt32(transferObj.TransferorRegNo.ToString())); htTransferRegInfo.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString())); htTransferRegInfo.Add("REG_BK_I", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_BR_I", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_NO_I", Convert.ToInt32(transferObj.TransfereeRegNo.ToString())); htTransferRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htTransferRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htTransferRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); htTransferRegInfo.Add("OLD_SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString()); commonGatewayObj.Insert(htTransferRegInfo, "TRANSFER"); } commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public DocDO(Docs.Api.Models.Doc d, UnitUser unitUser = null) : this() { if (d != null) { this.DocId = d.DocId; this.DocDirectionId = d.DocDirectionId; this.DocEntryTypeId = d.DocEntryTypeId; this.DocSourceTypeId = d.DocSourceTypeId; this.DocDestinationTypeId = d.DocDestinationTypeId; this.DocSubject = d.DocSubject; this.DocBody = d.DocBody; this.DocStatusId = d.DocStatusId; this.DocTypeId = d.DocTypeId; this.DocFormatTypeId = d.DocFormatTypeId; this.DocCasePartTypeId = d.DocCasePartTypeId; this.DocRegisterId = d.DocRegisterId; this.RegUri = d.RegUri; this.RegIndex = d.RegIndex; this.RegNumber = d.RegNumber; this.RegDate = d.RegDate; this.ExternalRegNumber = d.ExternalRegNumber; this.CorrRegNumber = d.CorrRegNumber; this.CorrRegDate = d.CorrRegDate; this.ReceiptOrder = d.ReceiptOrder; this.AccessCode = d.AccessCode; this.AssignmentTypeId = d.AssignmentTypeId; this.AssignmentDate = d.AssignmentDate; this.AssignmentDeadline = d.AssignmentDeadline; this.IsCase = d.IsCase; this.IsRegistered = d.IsRegistered; this.IsSigned = d.IsSigned; this.HasIncommingDocs = d.DocIncomingDocs != null && d.DocIncomingDocs.Any(); this.IsActive = d.IsActive; this.Version = d.Version; if (d.DocType != null) { this.DocTypeGroupId = d.DocType.DocTypeGroupId; this.DocTypeAlias = d.DocType.Alias; this.DocTypeName = d.DocType.Name; this.DocTypeIsElectronicService = d.DocType.IsElectronicService; } if (d.DocDirection != null) { this.DocDirectionAlias = d.DocDirection.Alias; this.DocDirectionName = d.DocDirection.Name; } if (d.DocEntryType != null) { this.DocEntryTypeAlias = d.DocEntryType.Alias; this.DocEntryTypeName = d.DocEntryType.Name; } if (d.DocStatus != null) { this.DocStatusAlias = d.DocStatus.Alias; this.DocStatusName = d.GetDocStatusName(); } if (d.DocCasePartType != null) { this.DocCasePartTypeAlias = d.DocCasePartType.Alias; this.DocCasePartTypeName = d.DocCasePartType.Name; } this.UnitUser = new UnitUserDO(unitUser); if (d.DocHasReads != null && unitUser != null) { this.IsRead = d.DocHasReads.Any(e => e.UnitId == unitUser.UnitId && e.HasRead); } if (d.DocSourceType != null) { this.IsElectronic = d.DocSourceType.Alias == "Internet"; } } }
public void saveTransferCDS(DataTable dtSaleTrInfo, UnitHolderRegistration regObj, UnitTransfer transferObj, UnitUser unitUserObj) { try { commonGatewayObj.BeginTransaction(); Hashtable htTransferRegInfo = new Hashtable(); StringBuilder sbQuery = new StringBuilder(); string[] saleNoArray; for (int loop = 0; loop < dtSaleTrInfo.Rows.Count; loop++) { if (dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().ToUpper().IndexOf('S') >= 0) { saleNoArray = dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().Split('S'); sbQuery.Append("UPDATE SALE SET QTY_OUT=NVL(QTY_OUT,0)+" + Convert.ToInt64(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString())); sbQuery.Append(" WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'"); sbQuery.Append(" AND REG_NO=" + Convert.ToInt32(regObj.RegNumber.ToString()) + " AND SL_NO=" + Convert.ToInt32(saleNoArray[1].ToString())); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("F_CD", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString())); htTransferRegInfo.Add("TR_DT", Convert.ToDateTime(transferObj.TransferDate.ToString()).ToString("dd-MMM-yyyy")); htTransferRegInfo.Add("REG_BK_O", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_BR_O", transferObj.TferorBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_NO_O", Convert.ToInt32(transferObj.TransferorRegNo.ToString())); htTransferRegInfo.Add("QTY", Convert.ToInt32(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString())); htTransferRegInfo.Add("REG_BK_I", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_BR_I", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_NO_I", Convert.ToInt32(transferObj.TransfereeRegNo.ToString())); htTransferRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htTransferRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htTransferRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); htTransferRegInfo.Add("OLD_SL_TR_NO", dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString()); commonGatewayObj.Insert(htTransferRegInfo, "TRANSFER"); } else if (dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().ToUpper().IndexOf('T') >= 0) { saleNoArray = dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().Split('T'); sbQuery.Append("UPDATE TRANSFER SET QTY_OUT=NVL(QTY_OUT,0)+" + Convert.ToInt64(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString())); sbQuery.Append(" WHERE F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND BR_CODE='" + regObj.FundCode.ToString() + "_" + regObj.BranchCode.ToString().ToUpper() + "'"); sbQuery.Append(" AND REG_NO_I=" + Convert.ToInt32(regObj.RegNumber.ToString()) + "AND TR_NO=" + Convert.ToInt32(saleNoArray[1].ToString())); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); htTransferRegInfo = new Hashtable(); htTransferRegInfo.Add("F_CD", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString())); htTransferRegInfo.Add("TR_DT", Convert.ToDateTime(transferObj.TransferDate.ToString()).ToString("dd-MMM-yyyy")); htTransferRegInfo.Add("REG_BK_O", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_BR_O", transferObj.TferorBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_NO_O", Convert.ToInt32(transferObj.TransferorRegNo.ToString())); htTransferRegInfo.Add("QTY", Convert.ToInt32(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString())); htTransferRegInfo.Add("REG_BK_I", regObj.FundCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_BR_I", transferObj.TfereeBranchCode.ToString().ToUpper()); htTransferRegInfo.Add("REG_NO_I", Convert.ToInt32(transferObj.TransfereeRegNo.ToString())); htTransferRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htTransferRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htTransferRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); htTransferRegInfo.Add("OLD_SL_TR_NO", dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString()); commonGatewayObj.Insert(htTransferRegInfo, "TRANSFER"); } } commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void SaveSaleEditInfoCDS(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, UnitUser unitUserObj) { Hashtable htUnitSale = new Hashtable(); Hashtable htUnitSaleCert = new Hashtable(); StringBuilder sbQuery = new StringBuilder(); try { commonGatewayObj.BeginTransaction(); htUnitSale.Add("SL_DT", Convert.ToDateTime(unitSaleObj.SaleDate).ToString("dd-MMM-yyyy")); htUnitSale.Add("SL_PRICE", Convert.ToDecimal(unitSaleObj.SaleRate.ToString())); htUnitSale.Add("QTY", Convert.ToInt32(unitSaleObj.SaleUnitQty.ToString())); htUnitSale.Add("SL_TYPE", unitSaleObj.SaleType.ToString().ToUpper()); if (!(unitSaleObj.MoneyReceiptNo.ToString() == "0")) { htUnitSale.Add("MONY_RECT_NO", Convert.ToInt32(unitSaleObj.MoneyReceiptNo)); } else { htUnitSale.Add("MONY_RECT_NO", DBNull.Value); } if (!((unitSaleObj.MoneyReceiptNo.ToString() == "0") && unitSaleObj.PaymentType.ToString() == "CHQ" && unitSaleObj.ChequeNo == null && unitSaleObj.ChequeDate == null)) { htUnitSale.Add("PAY_TYPE", unitSaleObj.PaymentType); } else { htUnitSale.Add("PAY_TYPE", DBNull.Value); } if (unitSaleObj.ChequeNo != null) { htUnitSale.Add("CHQ_DD_NO", unitSaleObj.ChequeNo); } else { htUnitSale.Add("CHQ_DD_NO", DBNull.Value); } if (unitSaleObj.ChequeDate == null) { htUnitSale.Add("CHEQUE_DT", DBNull.Value); } else { htUnitSale.Add("CHEQUE_DT", unitSaleObj.ChequeDate); } if (!(unitSaleObj.BankCode.ToString() == "0")) { htUnitSale.Add("BANK_CODE", Convert.ToInt16(unitSaleObj.BankCode)); } else { htUnitSale.Add("BANK_CODE", DBNull.Value); } if (!(unitSaleObj.BranchCode.ToString() == "0")) { htUnitSale.Add("BRANCH_CODE", Convert.ToInt16(unitSaleObj.BranchCode)); } else { htUnitSale.Add("BRANCH_CODE", DBNull.Value); } if (!(unitSaleObj.CashAmount.ToString() == "0")) { htUnitSale.Add("CASH_AMT", Convert.ToDecimal(unitSaleObj.CashAmount)); } else { htUnitSale.Add("CASH_AMT", DBNull.Value); } if (unitSaleObj.MultiPayType != null) { htUnitSale.Add("MULTI_PAY_REMARKS", unitSaleObj.MultiPayType); } else { htUnitSale.Add("MULTI_PAY_REMARKS", DBNull.Value); } commonGatewayObj.Update(htUnitSale, "SALE", "SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' "); sbQuery.Append(" INSERT INTO SALE_ED_INFO ( SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, "); sbQuery.Append(" CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT,USER_NM, EDIT_TYPE, ENT_DT ) "); sbQuery.Append(" SELECT SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT, "); sbQuery.Append(" '" + unitUserObj.UserID + "' USER_NM,'E' EDIT_TYPE ,'" + DateTime.Now.ToString("dd-MMM-yyyy") + "' ENT_DT FROM SALE "); sbQuery.Append(" WHERE SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void saveLienMarkCancel(DataTable dtTransferSaleCert, UnitHolderRegistration regObj, UnitLien unitLienObj, UnitUser unitUserObj) { try { UnitTransferBL unitTransferBLObj = new UnitTransferBL(); commonGatewayObj.BeginTransaction(); Hashtable htLienRegInfo = new Hashtable(); Hashtable htCertNoTemp = new Hashtable(); Hashtable htLienCancel = new Hashtable(); int SL_TR_RN = 0; int CertNo = 0; string certType = ""; string[] saleNoArray; string[] certArray; //string statusFlag = "L"; string Old_SL_TR_RN = ""; for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++) { if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0) { htLienRegInfo = new Hashtable(); // htLienRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); // htLienRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper()); // htLienRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString()); htLienRegInfo.Add("STATUS_FLAG", DBNull.Value); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('S'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htLienRegInfo, "SALE_CERT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "S" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('T') >= 0) { htLienRegInfo = new Hashtable(); //htLienRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); //htLienRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper()); //htLienRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString()); htLienRegInfo.Add("STATUS_FLAG", DBNull.Value); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('T'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htLienRegInfo, "TRANS_CERT", "F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND TR_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); //commonGatewayObj.Update(htLienRegInfo, "SALE_CERT", " REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); //commonGatewayObj.Update(htLienRegInfo, "RENEWAL_OUT", "REN_NO='" + SL_TR_RN + "' AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "T" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0) { htLienRegInfo = new Hashtable(); //htLienRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); //htLienRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper()); //htLienRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString()); htLienRegInfo.Add("STATUS_FLAG", DBNull.Value); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('R'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htLienRegInfo, "RENEWAL_OUT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REN_NO='" + SL_TR_RN + "' AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "R" + SL_TR_RN.ToString(); } htLienRegInfo = new Hashtable(); htLienRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper()); htLienRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper()); htLienRegInfo.Add("REG_NO", regObj.RegNumber.ToString()); htLienRegInfo.Add("LIEN_CANCL_NO", unitLienObj.LienCancelNo.ToString()); htLienRegInfo.Add("LIEN_NO", unitLienObj.LienNo.ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); htLienRegInfo.Add("CERT_TYPE", certArray[0].ToString().ToUpper()); htLienRegInfo.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString())); htLienRegInfo.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper()); htLienRegInfo.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString())); htLienRegInfo.Add("SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper()); commonGatewayObj.Insert(htLienRegInfo, "LIEN_MARK_CANCEL_CERT_NO"); htLienCancel = new Hashtable(); htLienCancel.Add("LN_MK_CANCEL", "Y"); commonGatewayObj.Update(htLienCancel, "LIEN_MARK_CERT_NO", "LIEN_NO='" + unitLienObj.LienNo.ToString() + "'AND REG_NO=" + Convert.ToInt32(regObj.RegNumber.ToString()) + " AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND CERT_TYPE='" + certArray[0].ToString().ToUpper() + "' AND CERT_NO=" + Convert.ToInt32(certArray[1].ToString())); } DataTable dtTransfer = unitTransferBLObj.dtTrnasfer(dtTransferSaleCert); for (int i = 0; i < dtTransfer.Rows.Count; i++) { htLienRegInfo = new Hashtable(); htLienRegInfo.Add("LIEN_CANCL_NO", unitLienObj.LienCancelNo.ToString()); htLienRegInfo.Add("LIEN_NO", unitLienObj.LienNo.ToString()); htLienRegInfo.Add("LN_CAN_LTR_DT", Convert.ToDateTime(unitLienObj.LienCancelReqDate.ToString()).ToString("dd-MMM-yyyy")); htLienRegInfo.Add("LIEN_CANCL_DT", Convert.ToDateTime(unitLienObj.LienCancelDate.ToString()).ToString("dd-MMM-yyyy")); htLienRegInfo.Add("LN_CAN_LTR_REF", unitLienObj.LienRefference.ToString()); htLienRegInfo.Add("LN_BK_CODE", Convert.ToInt16(unitLienObj.LienInst.ToString())); htLienRegInfo.Add("LN_BK_BR_CODE", Convert.ToInt16(unitLienObj.LienInstBranch.ToString())); htLienRegInfo.Add("SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString()); htLienRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper()); htLienRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper()); htLienRegInfo.Add("REG_NO", regObj.RegNumber.ToString()); htLienRegInfo.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString())); htLienRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htLienRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htLienRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); commonGatewayObj.Insert(htLienRegInfo, "LIEN_MARK_CANCEL"); } commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void DeleteSaleEditInfo(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, DataTable dtDinomination, UnitUser unitUserObj) { Hashtable htUnitSale = new Hashtable(); Hashtable htUnitSaleCert = new Hashtable(); Hashtable htCertNoTemp = new Hashtable(); string certificate = ""; try { commonGatewayObj.BeginTransaction(); htCertNoTemp.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper()); htCertNoTemp.Add("REG_BR", unitRegObj.BranchCode.ToString()); htCertNoTemp.Add("REG_NO", unitRegObj.RegNumber.ToString()); htCertNoTemp.Add("SL_NO", Convert.ToInt32(unitSaleObj.SaleNo.ToString())); htCertNoTemp.Add("SL_DT", Convert.ToDateTime(unitSaleObj.SaleDate).ToString("dd-MMM-yyyy")); htCertNoTemp.Add("SL_PRICE", Convert.ToDecimal(unitSaleObj.SaleRate.ToString())); htCertNoTemp.Add("QTY", Convert.ToInt32(unitSaleObj.SaleUnitQty.ToString())); htCertNoTemp.Add("SL_TYPE", unitSaleObj.SaleType.ToString().ToUpper()); if (!(unitSaleObj.MoneyReceiptNo.ToString() == "0")) { htCertNoTemp.Add("MONY_RECT_NO", Convert.ToInt32(unitSaleObj.MoneyReceiptNo)); } else { htCertNoTemp.Add("MONY_RECT_NO", DBNull.Value); } if (unitSaleObj.PaymentType != null) { htCertNoTemp.Add("PAY_TYPE", unitSaleObj.PaymentType); } else { htCertNoTemp.Add("PAY_TYPE", DBNull.Value); } if (unitSaleObj.ChequeNo != null) { htCertNoTemp.Add("CHQ_DD_NO", unitSaleObj.ChequeNo); } else { htCertNoTemp.Add("CHQ_DD_NO", DBNull.Value); } if (unitSaleObj.ChequeDate == null || unitSaleObj.ChequeDate == "") { htCertNoTemp.Add("CHEQUE_DT", DBNull.Value); } else { htCertNoTemp.Add("CHEQUE_DT", Convert.ToDateTime(unitSaleObj.ChequeDate).ToString("dd-MMM-yyyy")); } if (!(unitSaleObj.BankCode.ToString() == "0")) { htCertNoTemp.Add("BANK_CODE", Convert.ToInt16(unitSaleObj.BankCode)); } else { htCertNoTemp.Add("BANK_CODE", DBNull.Value); } if (!(unitSaleObj.BranchCode.ToString() == "0")) { htCertNoTemp.Add("BRANCH_CODE", Convert.ToInt16(unitSaleObj.BranchCode)); } else { htCertNoTemp.Add("BRANCH_CODE", DBNull.Value); } if (!(unitSaleObj.CashAmount.ToString() == null)) { htCertNoTemp.Add("CASH_AMT", Convert.ToDecimal(unitSaleObj.CashAmount)); } else { htCertNoTemp.Add("CASH_AMT", DBNull.Value); } if (unitSaleObj.MultiPayType != null) { htCertNoTemp.Add("MULTI_PAY_REMARKS", unitSaleObj.MultiPayType); } else { htCertNoTemp.Add("MULTI_PAY_REMARKS", DBNull.Value); } if (dtDinomination.Rows.Count > 0) { for (int looper = 0; looper < dtDinomination.Rows.Count; looper++) { if (certificate == "") { certificate = SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["CERT_NO"].ToString()), dtDinomination.Rows[looper]["CERT_TYPE"].ToString().ToUpper()); } else { certificate = certificate + "," + SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["CERT_NO"].ToString()), dtDinomination.Rows[looper]["CERT_TYPE"].ToString().ToUpper()); } } } if (certificate != "") { htCertNoTemp.Add("CERTIFICATE", certificate); } else { htCertNoTemp.Add("CERTIFICATE", DBNull.Value); } htCertNoTemp.Add("USER_NM", unitUserObj.UserID.ToString()); htCertNoTemp.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); htCertNoTemp.Add("ENT_DT", DateTime.Now.ToString()); htCertNoTemp.Add("EDIT_TYPE", "D"); commonGatewayObj.Insert(htCertNoTemp, "SALE_ED_INFO"); commonGatewayObj.DeleteByCommand("SALE", " SL_NO=" + unitSaleObj.SaleNo + " AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.DeleteByCommand("SALE_CERT", " SL_NO=" + unitSaleObj.SaleNo + " AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
protected void saveButton_Click(object sender, EventArgs e) { try { DataTable dtUserMenu = new DataTable(); dtUserMenu.Columns.Add("M_ID", typeof(string)); DataRow drUserMenu = dtUserMenu.NewRow(); DataTable dtUserFund = new DataTable(); dtUserFund.Columns.Add("FUND_CD", typeof(string)); DataRow drUserFund = dtUserFund.NewRow(); DataTable dtUserBranch = new DataTable(); dtUserBranch.Columns.Add("BR_CD", typeof(string)); DataRow drUserBranch = dtUserBranch.NewRow(); UnitUser userObj = new UnitUser(); UnitHolderRegistration regObj = new UnitHolderRegistration(); bool branchFlag = false; bool fundFlag = false; userObj.UserID = UserIDTextBox.Text.Trim().ToString(); userObj.UserPassword = encrypt.Encrypt(passwordTextBox.Text.Trim().ToString()); userObj.UserName = userNameTextBox.Text.Trim().ToString().ToUpper(); regObj.FundCode = fundNameDropDownList.SelectedValue.ToString(); regObj.BranchCode = branchNameDropDownList.SelectedValue.ToString(); if (menuCheckBoxList.Items.Count > 0) { for (int loop = 0; loop < menuCheckBoxList.Items.Count; loop++) { if (menuCheckBoxList.Items[loop].Selected) { drUserMenu = dtUserMenu.NewRow(); drUserMenu["M_ID"] = menuCheckBoxList.Items[loop].Value.ToString(); dtUserMenu.Rows.Add(drUserMenu); } } } if (branchCheckBoxList.Items.Count > 0) { for (int loop1 = 0; loop1 < branchCheckBoxList.Items.Count; loop1++) { if (branchCheckBoxList.Items[loop1].Selected) { drUserBranch = dtUserBranch.NewRow(); drUserBranch["BR_CD"] = branchCheckBoxList.Items[loop1].Value.ToString(); dtUserBranch.Rows.Add(drUserBranch); branchFlag = true; } } if (!branchFlag) { drUserBranch = dtUserBranch.NewRow(); drUserBranch["BR_CD"] = branchNameDropDownList.SelectedValue.ToString().ToUpper(); dtUserBranch.Rows.Add(drUserBranch); } } else { drUserBranch = dtUserBranch.NewRow(); drUserBranch["BR_CD"] = branchNameDropDownList.SelectedValue.ToString().ToUpper(); dtUserBranch.Rows.Add(drUserBranch); } if (fundCheckBoxList.Items.Count > 0) { for (int loop2 = 0; loop2 < fundCheckBoxList.Items.Count; loop2++) { if (fundCheckBoxList.Items[loop2].Selected) { drUserFund = dtUserFund.NewRow(); drUserFund["FUND_CD"] = fundCheckBoxList.Items[loop2].Value.ToString(); dtUserFund.Rows.Add(drUserFund); fundFlag = true; } } if (!fundFlag) { drUserFund = dtUserFund.NewRow(); drUserFund["FUND_CD"] = fundNameDropDownList.SelectedValue.ToString().ToUpper(); dtUserFund.Rows.Add(drUserFund); } } else { drUserFund = dtUserFund.NewRow(); drUserFund["FUND_CD"] = fundNameDropDownList.SelectedValue.ToString().ToUpper(); dtUserFund.Rows.Add(drUserFund); } if (dtUserMenu.Rows.Count > 0) { if (dtUserBranch.Rows.Count > 0) { if (dtUserFund.Rows.Count > 0) { if (userBLObj.CheckDuplicate(regObj, userObj)) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed: Duplicate User ID');", true); } else { userBLObj.saveUserMenue(regObj, userObj, dtUserBranch, dtUserFund, dtUserMenu); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "window.fnReset();alert ('User Created Successfully');", true); // ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Created Successfully');", true); } } else { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed: Please Checke Atleast One Fund ');", true); } } else { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed: Please Checke Atleast One Branch ');", true); } } else { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed: Please Checke Atleast One Menu ');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed:" + ex.Message.Replace("'", "").ToString() + "');", true); } }
public void DeleteSaleEditInfoCDS(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, UnitUser unitUserObj) { StringBuilder sbQuery = new StringBuilder(); try { commonGatewayObj.BeginTransaction(); commonGatewayObj.DeleteByCommand("SALE", "SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); sbQuery.Append(" INSERT INTO SALE_ED_INFO ( SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, "); sbQuery.Append(" CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT,USER_NM, EDIT_TYPE, ENT_DT ) "); sbQuery.Append(" SELECT SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT, "); sbQuery.Append(" '" + unitUserObj.UserID + "' USER_NM,'D' EDIT_TYPE ,'" + DateTime.Now.ToString("dd-MMM-yyyy") + "' ENT_DT FROM SALE "); sbQuery.Append(" WHERE SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void saveRepurchase(DataTable dtTransferSaleCert, UnitHolderRegistration regObj, UnitRepurchase repObj, UnitUser unitUserObj) { try { UnitTransferBL unitTransferBLObj = new UnitTransferBL(); commonGatewayObj.BeginTransaction(); Hashtable htRepurchaseRegInfo = new Hashtable(); Hashtable htCertNoTemp = new Hashtable(); int SL_TR_RN = 0; int CertNo = 0; string certType = ""; string[] saleNoArray; string[] certArray; string statusFlag = "R"; string Old_SL_TR_RN = ""; for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++) { if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0) { htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString()); htRepurchaseRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString()); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('S'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htRepurchaseRegInfo, "SALE_CERT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "S" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('T') >= 0) { htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString()); htRepurchaseRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString()); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('T'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htRepurchaseRegInfo, "TRANS_CERT", "F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); commonGatewayObj.Update(htRepurchaseRegInfo, "SALE_CERT", "REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); commonGatewayObj.Update(htRepurchaseRegInfo, "RENEWAL_OUT", "REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "T" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0) { htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString()); htRepurchaseRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString()); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('R'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htRepurchaseRegInfo, "RENEWAL_OUT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "R" + SL_TR_RN.ToString(); } htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REP_NO", Convert.ToInt32(repObj.RepurchaseNo.ToString())); htRepurchaseRegInfo.Add("REG_NO", Convert.ToInt32(regObj.RegNumber.ToString())); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); htRepurchaseRegInfo.Add("CERT_TYPE", certArray[0].ToString().ToUpper()); htRepurchaseRegInfo.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString())); htRepurchaseRegInfo.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper()); htRepurchaseRegInfo.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString())); htRepurchaseRegInfo.Add("SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper()); commonGatewayObj.Insert(htRepurchaseRegInfo, "REP_CERT_NO"); } DataTable dtTransfer = unitTransferBLObj.dtTrnasfer(dtTransferSaleCert); for (int i = 0; i < dtTransfer.Rows.Count; i++) { htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("REP_NO", Convert.ToInt32(repObj.RepurchaseNo.ToString())); htRepurchaseRegInfo.Add("REP_DT", Convert.ToDateTime(repObj.RepurchaseDate.ToString()).ToString("dd-MMM-yyyy")); htRepurchaseRegInfo.Add("SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString()); htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_NO", regObj.RegNumber.ToString()); htRepurchaseRegInfo.Add("REP_PRICE", decimal.Parse(repObj.RepurchaseRate.ToString())); htRepurchaseRegInfo.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString())); htRepurchaseRegInfo.Add("PAY_TYPE", repObj.PayType.ToString().ToUpper()); htRepurchaseRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htRepurchaseRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htRepurchaseRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); if (repObj.ChequeIssueTo == null) { htRepurchaseRegInfo.Add("CHQ_ISSUE_TO", DBNull.Value); } else { htRepurchaseRegInfo.Add("CHQ_ISSUE_TO", repObj.ChequeIssueTo.ToString()); } commonGatewayObj.Insert(htRepurchaseRegInfo, "REPURCHASE"); } commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void AssignUserToUnit(int unitId, int userId) { var unit = unitsInContext.SingleOrDefault(e => e.UnitId == unitId && (Docs.Api.Models.DomainModels.UnitType)e.UnitTypeId == Docs.Api.Models.DomainModels.UnitType.Employee && e.IsActive); if (unit == null) { validator.AddErrorMessage(DomainErrorCode.Unit_NotFound_ActivOfTypeEmployee); } var user = unitOfWork.DbContext.Set<User>().SingleOrDefault(e => e.UserId == userId && e.IsActive); if (user == null) { validator.AddErrorMessage(DomainErrorCode.Entity_NotFoundOrNotActive); } validator.Validate(); var unitUsersInContext = unitOfWork.DbContext.Set<UnitUser>(); var doesUnitAlreadyExistInRelation = unitUsersInContext.Any(e => e.UnitId == unitId && e.IsActive); if (doesUnitAlreadyExistInRelation) { validator.AddErrorMessage(DomainErrorCode.Entity_AlreadyExistInRelation); } var doesUserAlreadyExistInRelation = unitUsersInContext.Any(e => e.UserId == userId && e.IsActive); if (doesUserAlreadyExistInRelation) { validator.AddErrorMessage(DomainErrorCode.Entity_AlreadyExistInRelation); } validator.Validate(); var unitUser = new UnitUser { Unit = unit, User = user }; unitOfWork.DbContext.Set<UnitUser>() .Add(unitUser); unitOfWork.Save(); }
public void SaveUnitRenewal(UnitHolderRegistration unitRegObj, DataTable dtTransferSaleCert, UnitRenewal renwalObj, DataTable dtDinomination, UnitUser unitUserObj) { Hashtable htUnitSaleCert = new Hashtable(); Hashtable htRenwal = new Hashtable(); Hashtable htRenewalIN = new Hashtable(); Hashtable htRenewalOUT = new Hashtable(); UnitTransferBL unitTransferBLObj = new UnitTransferBL(); int SL_TR_RN = 0; int CertNo = 0; string certType = ""; string[] saleNoArray; string[] certArray; string valid = "N"; string remarks = "RENEWAL NO:" + renwalObj.RenewalNo.ToString(); string Old_SL_TR_RN = ""; string FORM_CODE = ""; if (renwalObj.RenewalType.ToString().ToUpper() == "S" || renwalObj.RenewalType.ToString().ToUpper() == "C") { FORM_CODE = "UNIT-UMA"; } else if (renwalObj.RenewalType.ToString().ToUpper() == "S") { FORM_CODE = "UNIT-CHA"; } try { commonGatewayObj.BeginTransaction(); for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++) { if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0) { htUnitSaleCert = new Hashtable(); htUnitSaleCert.Add("VALID", valid); htUnitSaleCert.Add("REMARKS", remarks); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('S'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htUnitSaleCert, "SALE_CERT", "REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "S" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('T') >= 0) { htUnitSaleCert = new Hashtable(); htUnitSaleCert.Add("VALID", valid); htUnitSaleCert.Add("REMARKS", remarks); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('T'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htUnitSaleCert, "TRANS_CERT", "F_CD='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND TR_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); // commonGatewayObj.Update(htUnitSaleCert, "SALE_CERT", " REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); // commonGatewayObj.Update(htUnitSaleCert, "RENEWAL_OUT", "REN_NO='" + SL_TR_RN + "' AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "T" + SL_TR_RN.ToString(); } else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0) { htUnitSaleCert = new Hashtable(); htUnitSaleCert.Add("VALID", valid); htUnitSaleCert.Add("REMARKS", remarks); saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('R'); SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); CertNo = Convert.ToInt32(certArray[1].ToString()); certType = certArray[0].ToString().ToUpper(); commonGatewayObj.Update(htUnitSaleCert, "RENEWAL_OUT", "REN_NO='" + SL_TR_RN + "' AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'"); Old_SL_TR_RN = "R" + SL_TR_RN.ToString(); } htRenewalIN = new Hashtable(); htRenewalIN.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper()); htRenewalIN.Add("REG_BR", unitRegObj.BranchCode.ToString().ToUpper()); htRenewalIN.Add("REG_NO", Convert.ToInt32(unitRegObj.RegNumber.ToString())); htRenewalIN.Add("REN_NO", renwalObj.RenewalNo.ToString()); certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-'); htRenewalIN.Add("CERT_TYPE", certArray[0].ToString().ToUpper()); htRenewalIN.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString())); htRenewalIN.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper()); htRenewalIN.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString())); htRenewalIN.Add("SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper()); commonGatewayObj.Insert(htRenewalIN, "RENEWAL_IN"); } DataTable dtTransfer = unitTransferBLObj.dtTrnasfer(dtTransferSaleCert); for (int i = 0; i < dtTransfer.Rows.Count; i++) //Insert Into Renewal Table { htRenwal = new Hashtable(); htRenwal.Add("REN_NO", renwalObj.RenewalNo.ToString()); htRenwal.Add("REN_DT", Convert.ToDateTime(renwalObj.RenewalDate).ToString("dd-MMM-yyyy")); htRenwal.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper()); htRenwal.Add("REG_BR", unitRegObj.BranchCode.ToString()); htRenwal.Add("REG_NO", Convert.ToInt32(unitRegObj.RegNumber.ToString())); htRenwal.Add("FORM_CODE", FORM_CODE); htRenwal.Add("SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString()); htRenwal.Add("REN_TYPE", renwalObj.RenewalType.ToString().ToUpper()); htRenwal.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString())); htRenwal.Add("USER_NM", unitUserObj.UserID.ToString()); htRenwal.Add("ENT_DT", DateTime.Now.ToString()); htRenwal.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); commonGatewayObj.Insert(htRenwal, "RENEWAL"); } for (int looper = 0; looper < dtDinomination.Rows.Count; looper++)//Insert Into RenewalOut Table { htRenewalOUT = new Hashtable(); htRenewalOUT.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper()); htRenewalOUT.Add("REG_BR", unitRegObj.BranchCode.ToString()); htRenewalOUT.Add("REG_NO", Convert.ToInt32(unitRegObj.RegNumber.ToString())); htRenewalOUT.Add("REN_NO", renwalObj.RenewalNo.ToString()); htRenewalOUT.Add("CERT_TYPE", dtDinomination.Rows[looper]["dino"].ToString().ToUpper()); htRenewalOUT.Add("CERT_NO", Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString())); htRenewalOUT.Add("CERTIFICATE", SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()), dtDinomination.Rows[looper]["dino"].ToString().ToUpper())); htRenewalOUT.Add("QTY", Convert.ToInt32(dtDinomination.Rows[looper]["cert_weight"].ToString())); commonGatewayObj.Insert(htRenewalOUT, "RENEWAL_OUT"); } commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void saveRepurchaseCDS(DataTable dtSaleTrInfo, UnitHolderRegistration regObj, UnitRepurchase repObj, UnitUser unitUserObj) { try { commonGatewayObj.BeginTransaction(); Hashtable htRepurchaseRegInfo = new Hashtable(); StringBuilder sbQuery = new StringBuilder(); string[] saleNoArray; for (int loop = 0; loop < dtSaleTrInfo.Rows.Count; loop++) { if (dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().ToUpper().IndexOf('S') >= 0) { sbQuery = new StringBuilder(); saleNoArray = dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().Split('S'); sbQuery.Append("UPDATE SALE SET QTY_OUT=NVL(QTY_OUT,0)+" + Convert.ToInt64(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString())); sbQuery.Append(" WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'"); sbQuery.Append(" AND REG_NO=" + Convert.ToInt32(regObj.RegNumber.ToString()) + " AND SL_NO=" + Convert.ToInt32(saleNoArray[1].ToString())); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("REP_NO", repObj.RepurchaseNo); htRepurchaseRegInfo.Add("REP_DT", repObj.RepurchaseDate); htRepurchaseRegInfo.Add("SL_TR_NO", dtSaleTrInfo.Rows[loop]["SL_TR_NO"]); htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_NO", regObj.RegNumber.ToString()); htRepurchaseRegInfo.Add("REP_PRICE", repObj.RepurchaseRate); htRepurchaseRegInfo.Add("QTY", dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"]); htRepurchaseRegInfo.Add("PAY_TYPE", repObj.PayType.ToString().ToUpper()); htRepurchaseRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htRepurchaseRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htRepurchaseRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); commonGatewayObj.Insert(htRepurchaseRegInfo, "REPURCHASE"); } else if (dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().ToUpper().IndexOf('T') >= 0) { sbQuery = new StringBuilder(); saleNoArray = dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().Split('T'); sbQuery.Append("UPDATE TRANSFER SET QTY_OUT=NVL(QTY_OUT,0)+" + Convert.ToInt64(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString())); sbQuery.Append(" WHERE F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND BR_CODE='" + regObj.FundCode.ToString() + "_" + regObj.BranchCode.ToString().ToUpper() + "'"); sbQuery.Append(" AND REG_NO_I=" + Convert.ToInt32(regObj.RegNumber.ToString()) + " AND TR_NO=" + Convert.ToInt32(saleNoArray[1].ToString())); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); htRepurchaseRegInfo = new Hashtable(); htRepurchaseRegInfo.Add("REP_NO", repObj.RepurchaseNo); htRepurchaseRegInfo.Add("REP_DT", repObj.RepurchaseDate); htRepurchaseRegInfo.Add("SL_TR_NO", dtSaleTrInfo.Rows[loop]["SL_TR_NO"]); htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper()); htRepurchaseRegInfo.Add("REG_NO", regObj.RegNumber.ToString()); htRepurchaseRegInfo.Add("REP_PRICE", repObj.RepurchaseRate); htRepurchaseRegInfo.Add("QTY", dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"]); htRepurchaseRegInfo.Add("PAY_TYPE", repObj.PayType.ToString().ToUpper()); htRepurchaseRegInfo.Add("USER_NM", unitUserObj.UserID.ToString()); htRepurchaseRegInfo.Add("ENT_DT", DateTime.Now.ToString()); htRepurchaseRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); commonGatewayObj.Insert(htRepurchaseRegInfo, "REPURCHASE"); } } commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void SaveUnitSaleCDS(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, UnitUser unitUserObj) { Hashtable htUnitSale = new Hashtable(); try { commonGatewayObj.BeginTransaction(); htUnitSale.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper()); htUnitSale.Add("REG_BR", unitRegObj.BranchCode.ToString()); htUnitSale.Add("REG_NO", unitRegObj.RegNumber.ToString()); htUnitSale.Add("SL_NO", Convert.ToInt32(unitSaleObj.SaleNo.ToString())); htUnitSale.Add("SL_DT", Convert.ToDateTime(unitSaleObj.SaleDate).ToString("dd-MMM-yyyy")); htUnitSale.Add("SL_PRICE", Convert.ToDecimal(unitSaleObj.SaleRate.ToString())); htUnitSale.Add("QTY", Convert.ToInt32(unitSaleObj.SaleUnitQty.ToString())); htUnitSale.Add("SL_TYPE", unitSaleObj.SaleType.ToString().ToUpper()); htUnitSale.Add("USER_NM", unitUserObj.UserID.ToString()); htUnitSale.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); htUnitSale.Add("ENT_DT", DateTime.Now.ToString()); if (!(unitSaleObj.MoneyReceiptNo.ToString() == "0")) { htUnitSale.Add("MONY_RECT_NO", Convert.ToInt32(unitSaleObj.MoneyReceiptNo)); } if (!((unitSaleObj.MoneyReceiptNo.ToString() == "0") && unitSaleObj.PaymentType.ToString() == "CHQ" && unitSaleObj.ChequeNo == null && unitSaleObj.ChequeDate == null)) { htUnitSale.Add("PAY_TYPE", unitSaleObj.PaymentType); } if (unitSaleObj.ChequeNo != null) { htUnitSale.Add("CHQ_DD_NO", unitSaleObj.ChequeNo); } if (unitSaleObj.ChequeDate == null) { htUnitSale.Add("CHEQUE_DT", DBNull.Value); } else { htUnitSale.Add("CHEQUE_DT", unitSaleObj.ChequeDate); } if (!(unitSaleObj.BankCode.ToString() == "0")) { htUnitSale.Add("BANK_CODE", Convert.ToInt16(unitSaleObj.BankCode)); } if (!(unitSaleObj.BranchCode.ToString() == "0")) { htUnitSale.Add("BRANCH_CODE", Convert.ToInt16(unitSaleObj.BranchCode)); } if (!(unitSaleObj.CashAmount.ToString() == "0")) { htUnitSale.Add("CASH_AMT", Convert.ToDecimal(unitSaleObj.CashAmount)); } if (unitSaleObj.MultiPayType != null) { htUnitSale.Add("MULTI_PAY_REMARKS", unitSaleObj.MultiPayType); } commonGatewayObj.Insert(htUnitSale, "SALE"); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }