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