protected void btnDelete_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdBranchID.Value))
{
BranchDAL oBranchDAL = new BranchDAL();
Result oResult = (Result)oBranchDAL.Detete(hdBranchID.Value);
if (oResult.Status)
{
this.LoadList();
ClearTextValue();
hdBranchID.Value = "";
ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
}
else
{
if (oResult.Message.Equals(Constants.TABLE_MAIN))
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
public void LoadList()
{
Branch oBranch = new Branch();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
BranchDAL oBranchDAL = new BranchDAL();
Result oResult = oBranchDAL.LoadUnapprovedList(oConfig.UserName, false);
if (oResult.Status)
{
DataTable dtTmpBranchList = (DataTable)oResult.Return;
if (dtTmpBranchList.Rows.Count > 0)
{
dtTmpBranchList.Columns.Remove("MakerID");
gvBranchList.DataSource = dtTmpBranchList;
gvBranchList.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpBranchList;
}
else
{
gvBranchList.DataSource = null;
gvBranchList.DataBind();
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
}
private static (List <VM_Branch> branches, List <BranchMeter> branchMeters) getBranchesAndBranchMeter(int PID)
{
//读取所有仪表
var meters = MeterDAL.GetViewListByPID(PID);
//读取所有支路
var branches = BranchDAL.GetViewListByPID(PID);
var branchMeters = ModelLink.BranchMeterLink(branches, meters);
return(branches, branchMeters);
}
public Boolean Delete(SqlInt32 BranchID)
{
BranchDAL branchDAL = new BranchDAL();
if (branchDAL.Delete(BranchID))
{
return(true);
}
else
{
this.Message = branchDAL.Message;
return(false);
}
}
public Boolean Update(BranchENT entBranch)
{
BranchDAL branchDAL = new BranchDAL();
if (branchDAL.Update(entBranch))
{
return(true);
}
else
{
this.Message = branchDAL.Message;
return(false);
}
}
private void LoadDataByID(string sBranchID)
{
Branch oBranch = new Branch(sBranchID);
BranchDAL oBranchDAL = new BranchDAL();
Result oResult = new Result();
oResult = oBranchDAL.LoadByID(oBranch);
if (oResult.Status)
{
oBranch = (Branch)oResult.Return;
txtBranchID.Text = oBranch.BranchID.Trim();
txtBranchID.ReadOnly = true;
txtBranchName.Text = oBranch.BranchName;
txtBdBankCode.Text = oBranch.BbCode;
txtAddress.Text = oBranch.Address;
txtZipCode.Text = oBranch.ZipCode;
txtPhoneNumber.Text = oBranch.Phone;
txtEmailID.Text = oBranch.Email;
txtFaxNumber.Text = oBranch.Fax;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oBranch.UserDetails.MakerID;
userDetails.MakeDate = oBranch.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oBranch.UserDetails.CheckDate;
userDetails.CheckerID = oBranch.UserDetails.CheckerID;
userDetails.CheckDate = oBranch.UserDetails.CheckDate;
userDetails.CheckerComment = oBranch.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
DDListUtil.Assign(ddlCountryName, oBranch.Country.ToString());
hdBranchID.Value = sBranchID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
CustomerType oCustomerType = new CustomerType();
Result oResult = new Result();
if (Type.Equals("BankSearch"))
{
BankDAL oBDAL = new BankDAL();
oResult = oBDAL.AppSearchList(txtID.Text, txtName.Text);
}
else if (Type.Equals("DivisionSearch"))
{
DivisionDAL oDivisionDAL = new DivisionDAL();
oResult = oDivisionDAL.AppSearchList(txtID.Text, txtName.Text);
}
else if (Type.Equals("CurrencySearch"))
{
CurrencyDAL oCurrencyDAL = new CurrencyDAL();
oResult = oCurrencyDAL.AppSearchList(txtID.Text, txtName.Text);
}
else if (Type.Equals("BranchSearch"))
{
BranchDAL oBranchDAL = new BranchDAL();
oResult = oBranchDAL.AppSearchList(txtID.Text, txtName.Text);
}
ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchConfComm_lblProgress') ", true);
if (oResult.Status)
{
DataTable dtTmpCustomerTypeList = (DataTable)oResult.Return;
if (dtTmpCustomerTypeList.Rows.Count > 0)
{
gvSearchList.DataSource = dtTmpCustomerTypeList;
gvSearchList.DataBind();
}
else
{
gvSearchList.DataSource = null;
gvSearchList.DataBind();
}
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpCustomerTypeList;
}
ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchConfComm_lblProgress') ", true);
}
public ResultBM GetBranch(int branchId)
{
try
{
AddressBLL addressBll = new AddressBLL();
ResultBM addressResult = null;
BranchDAL branchDal = new BranchDAL();
BranchDTO branchDto = branchDal.GetBranch(branchId);
BranchBM branchBm = null;
//Si la sede existe, debería existir la dirección
if (branchDto != null)
{
addressResult = addressBll.GetAddress(branchDto.addressId);
if (addressResult.IsValid())
{
if (addressResult.GetValue() != null)
{
branchBm = new BranchBM(branchDto, addressResult.GetValue <AddressBM>());
}
else
{
return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("RETRIEVING_ERROR")));
}
}
else
{
return(addressResult);
}
}
return(new ResultBM(ResultBM.Type.OK, "Operación exitosa.", branchBm));
}
catch (Exception exception)
{
return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("RETRIEVING_ERROR") + " " + exception.Message, exception));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Branch oBranch = new Branch();
BranchDAL oBranchDAL = new BranchDAL();
oBranch.BranchID = Request[txtBranchID.UniqueID].Trim().ToUpper();
txtBranchID.Text = Request[txtBranchID.UniqueID].Trim().ToUpper();
oBranch.BranchName = txtBranchName.Text.ToUpper();
oBranch.BbCode = txtBdBankCode.Text;
oBranch.Address = txtAddress.Text;
oBranch.ZipCode = txtZipCode.Text;
oBranch.Phone = txtPhoneNumber.Text;
if (!string.IsNullOrEmpty(ddlCountryName.SelectedItem.Value))
{
oBranch.Country = ddlCountryName.SelectedItem.Value;
}
oBranch.Email = txtEmailID.Text;
oBranch.Fax = txtFaxNumber.Text;
oBranch.UserDetails = ucUserDet.UserDetail;
oBranch.UserDetails.MakeDate = DateTime.Now;
ucUserDet.ResetData();
Result oResult = (Result)oBranchDAL.Save(oBranch);
if (oResult.Status)
{
this.LoadList();
ClearTextValue();
hdBranchID.Value = "";
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
// ScriptManager.RegisterStartupScript(this.upData, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Save"), true);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
// ScriptManager.RegisterStartupScript(this.upData, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Save"), true);
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdBranchID.Value))
{
Branch oBranch = new Branch(hdBranchID.Value);
BranchDAL oBranchDAL = new BranchDAL();
oBranch.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oBranchDAL.Reject(oBranch);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_REJECT, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdBranchID.Value))
{
Branch oBranch = new Branch(hdBranchID.Value);
BranchDAL oBranchDAL = new BranchDAL();
oBranch.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oBranchDAL.Approve(oBranch);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE + " with<BR> <b>Branch Code: " + txtBranchID.Text + " : " + txtBranchName.Text.ToUpper() + "</B>", Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
protected void createButton_Click(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Write("<script>alert('please login.');window.location.href='login.aspx';</script>");
return;
}
if (name.Value.Length == 0 || desc.Value.Length == 0)
{
Response.Write("<script>alert('emoty data');</script>");
return;
}
//create warehouse
User u = Session["user"] as User;
Warehouse w = new Warehouse();
WarehouseDAL wd = new WarehouseDAL();
w.user_id = u.user_id;
w.warehouse_name = name.Value;
w.warehouse_description = desc.Value;
if (wd.Insert(ref w))
{
}
else
{
Response.Write("<script>alert('error: warehouse insert');</script>");
return;
}
//create first version
Version v = new Version();
VersionDAL vd = new VersionDAL();
v.user_id = u.user_id;
v.warehouse_id = w.warehouse_id;
v.version_name = "master";
v.description = "master";
if (vd.Insert(ref v))
{
w.master_version_id = v.version_id;
}
else
{
//delete warehouse
wd.Delete(ref w);
Response.Write("<script>alert('error: version insert');</script>");
return;
}
if (wd.Update(ref w))
{
}
else
{
//delete warehouse and version
wd.Delete(ref w);
vd.Delete(ref v);
Response.Write("<script>alert('error: warehouse update');</script>");
return;
}
//insert branch
Branch b = new Branch();
BranchDAL bd = new BranchDAL();
b.warehouse_id = w.warehouse_id;
b.user_id = u.user_id;
b.start_id = v.version_id;
b.end_id = 0;
b.branch_name = "master";
b.description = "master";
if (bd.Insert(ref b))
{
}
else
{
Response.Write("<script>alert('error: branch insert');</script>");
wd.Delete(ref w);
vd.Delete(ref v);
return;
}
v.branch_id = b.branch_id;
if (!vd.Update(ref v))
{
Response.Write("<script>alert('error: version update');</script>");
wd.Delete(ref w);
vd.Delete(ref v);
bd.Delete(b.branch_id);
return;
}
//crete files
if (FileSystem.CreateFolder(Server.MapPath("~/") + @"data\" + w.warehouse_id.ToString() + @"\" + v.version_id.ToString()) == false)
{
Response.Write("<script>alert('error: file error');</script>");
wd.Delete(ref w);
vd.Delete(ref v);
bd.Delete(b.branch_id);
return;
}
//create success
Response.Write("<script>alert('create success.');window.location.href='user_page.aspx?uid=" + u.user_id.ToString() + "';</script>");
}
public BranchBO()
{
branchDAL = new BranchDAL();
}
protected void createButton_Click(object sender, EventArgs e)
{
if (name.Value.Length == 0 || desc.Value.Length == 0)
{
//error
Response.Write("<script>alert('invalid name or desc.');</script>");
return;
}
if (name.Value == "master")
{
Response.Write("<script>alert('invalid name.');</script>");
return;
}
Version v2 = new Version();
v2.version_name = name.Value;
v2.description = desc.Value;
v2.prev_id = v.version_id;
v2.next_id = 0;
v2.warehouse_id = v.warehouse_id;
v2.user_id = v.user_id;
v2.branch_id = 0;//warning
if (!vd.Insert(ref v2))
{
Response.Write("<script>alert('insert error 1.');</script>");
return;
}
Branch b = new Branch();
b.branch_name = name.Value;
b.description = desc.Value;
b.warehouse_id = v.warehouse_id;
b.user_id = v.user_id;
b.start_id = v2.version_id;
b.end_id = 0;
bd = new BranchDAL();
if (!bd.Insert(ref b))
{
Response.Write("<script>alert('insert error 2.');</script>");
vd.Delete(ref v2);
return;
}
v2.branch_id = b.branch_id;
if (!vd.Update(ref v2))
{
Response.Write("<script>alert('update error.');</script>");
vd.Delete(ref v2);
bd.Delete(b.branch_id);
return;
}
//create files
if (!FileSystem.CopyFolder(Server.MapPath("~/") + @"data\" + v.warehouse_id.ToString() + @"\" + v.version_id.ToString(), Server.MapPath("~/") + @"data\" + v.warehouse_id.ToString() + @"\" + v2.version_id.ToString()))
{
vd.Delete(ref v2);
bd.Delete(b.branch_id);
Response.Write("<script>alert('file error.');</script>");
return;
}
Response.Write("<script>alert('create success.');</script>");
Response.Redirect("warehouse_page.aspx?vid=" + v.version_id.ToString() + "&wid=" + v.warehouse_id.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
wd = new WarehouseDAL();
vd = new VersionDAL();
bd = new BranchDAL();
if (int.TryParse(Request.QueryString["wid"], out wid) == false)
{
//error
}
if (int.TryParse(Request.QueryString["vid"], out vid) == false)
{
//error
}
if (wid == 0 || vid == 0)
{
//error
}
//debug!!!!!!!!!!!!!!!!!!!!!!!
//wid = 1;
//vid = 1;
//User u = new User();
//u.user_id = 1;
//UserDAL ud = new UserDAL();
//ud.SelectByID(ref u);
//Session["user"] = u;
w = new Warehouse();
w.warehouse_id = wid;
if (!wd.SelectedByID(ref w))
{
//error
}
v = new Version();
v.version_id = vid;
if (!vd.SelectByID(ref v))
{
//error
}
b = new Branch();
b.branch_id = v.branch_id;
if (!bd.SelectByID(ref b))
{
//error
}
//head
headName.InnerText = w.warehouse_name;
headDesc.InnerText = w.warehouse_description;
//current version
curBran.InnerText = "当前分支：" + b.branch_name;
curVer.InnerText = "当前版本：" + v.version_id.ToString();
curTime.InnerText = "修改时间：" + v.timestamp;
curDesc.InnerText = "当前版本描述：" + v.description;
//draw
if (!DrawGraph())
{
}
//file
fileInit();
}
public void SearchAction()
{
string sType = Request.QueryString["pType"];
gvData.DataSource = null;
gvData.DataBind();
if (!string.IsNullOrEmpty(sType))
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BRANCH).PadLeft(5, '0')))
{
#region BRANCH
lgText.InnerHtml = "Branch Approval Queue List";
BranchDAL oBranchDAL = new BranchDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Branch' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oBranchDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Branch ID";
this.gvData.HeaderRow.Cells[2].Text = "Branch Name";
this.gvData.HeaderRow.Cells[3].Text = "BB Code";
this.gvData.HeaderRow.Cells[4].Text = "Address";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion BRANCH
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BD_BANKADDRESS).PadLeft(5, '0')))
{
#region Bangladesh Bank Address
lgText.InnerHtml = "Bangladesh Bank Address Approval Queue List";
BBAddressDAL oBBAddressDAL = new BBAddressDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Bangladesh Bank Address' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oBBAddressDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet Address";
this.gvData.HeaderRow.Cells[3].Text = "Commission Claim Address";
this.gvData.HeaderRow.Cells[4].Text = "Interest Claim Address";
this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim Address";
this.gvData.HeaderRow.Cells[6].Text = "Reinvestment Address";
this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
this.gvData.HeaderRow.Cells[8].Text = "Make Date";
}
}
}
#endregion Bangladesh Bank Address
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY).PadLeft(5, '0')))
{
#region Currency
lgText.InnerHtml = "Currency Approval Queue List";
CurrencyDAL oCurrencyDAL = new CurrencyDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Currency' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCurrencyDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
this.gvData.HeaderRow.Cells[3].Text = "Currency Symbol";
this.gvData.HeaderRow.Cells[4].Text = "Currency Description";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion Currency
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY_WISE_ACCOUNT_MAPPING).PadLeft(5, '0')))
{
#region Currency Wise Account Mapping
lgText.InnerHtml = "Currency Wise Account Mapping Approval Queue List";
CurrencyWiseAccountMappingDAL oCurrencyWiseAccountMappingDAL = new CurrencyWiseAccountMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Currency Wise Account Mapping ' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCurrencyWiseAccountMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
// for adding seperator....
alAddSeperatorIndex = new ArrayList();
alAddSeperatorIndex.Add(3);
alAddSeperatorIndex.Add(4);
alAddSeperatorIndex.Add(5);
alAddSeperatorIndex.Add(6);
alAddSeperatorIndex.Add(7);
dtTmpList.Columns.Remove("SuspenseAccName");
dtTmpList.Columns.Remove("ForeignExchangeAccName");
dtTmpList.Columns.Remove("BranchFxAccName");
dtTmpList.Columns.Remove("BranchExFxAccName");
dtTmpList.Columns.Remove("BangladesgBankAccName");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
this.gvData.HeaderRow.Cells[3].Text = "Suspense Acc";
this.gvData.HeaderRow.Cells[4].Text = "Foreign Exchange Acc";
this.gvData.HeaderRow.Cells[5].Text = "Branch Fx Acc";
this.gvData.HeaderRow.Cells[6].Text = "Branch Ex Fx Acc";
this.gvData.HeaderRow.Cells[7].Text = "Bangladesg Bank Acc";
this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
this.gvData.HeaderRow.Cells[9].Text = "Make Date";
}
}
}
#endregion Currency Wise Account Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_DETAIL).PadLeft(5, '0')))
{
#region Customer Detail
lgText.InnerHtml = "Customer Detail Approval Queue List";
CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Customer Detail' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCustomerDetailsDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer ID";
this.gvData.HeaderRow.Cells[2].Text = "Customer Name";
this.gvData.HeaderRow.Cells[3].Text = "Date of Birth";
this.gvData.HeaderRow.Cells[4].Text = "Address";
this.gvData.HeaderRow.Cells[5].Text = "Phone";
this.gvData.HeaderRow.Cells[6].Text = "Email";
this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
this.gvData.HeaderRow.Cells[8].Text = "Make Date";
}
}
}
#endregion Customer Detail
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE).PadLeft(5, '0')))
{
#region Customer Type
lgText.InnerHtml = "Customer Type Approval Queue List";
CustomerTypeDAL oCustomerTypeDAL = new CustomerTypeDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Customer Type' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCustomerTypeDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
this.gvData.HeaderRow.Cells[2].Text = "Customer Type Description";
this.gvData.HeaderRow.Cells[3].Text = "Max Members";
this.gvData.HeaderRow.Cells[4].Text = "Is Organization";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion Customer Type
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE_WISE_SP_LIMIT).PadLeft(5, '0')))
{
#region Customer Type wise SP Type Maping
lgText.InnerHtml = "Customer Type wise SP Type Maping Approval Queue List";
CustomerTypeWiseSPLimitDAL oCustomerTypeWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Customer Type wise Sp Type Maping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCustomerTypeWiseSPLimitDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
this.gvData.HeaderRow.Cells[2].Text = "Customer Type";
this.gvData.HeaderRow.Cells[3].Text = "SP Type";
this.gvData.HeaderRow.Cells[4].Text = "Minimum Limit";
this.gvData.HeaderRow.Cells[5].Text = "Maximum Limit";
this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
this.gvData.HeaderRow.Cells[7].Text = "Make Date";
}
}
}
#endregion Customer Type wise SP Type Maping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.DIVISION).PadLeft(5, '0')))
{
#region Area Approval
lgText.InnerHtml = "Area Approval Queue List";
DivisionDAL oDivisionDAL = new DivisionDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Area' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oDivisionDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("BranchID");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Area ID";
this.gvData.HeaderRow.Cells[2].Text = "BB Code";
this.gvData.HeaderRow.Cells[3].Text = "Area Name";
this.gvData.HeaderRow.Cells[4].Text = "Address";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion Area Approval
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_CERTIFICATE).PadLeft(5, '0')))
{
#region Script Mapping Certificate
lgText.InnerHtml = "Script Mapping Certificate Approval Queue List";
ScripMappingDAL oScripMappingDAL = new ScripMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Script Mapping Certificate' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oScripMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList = DDListUtil.MapTableWithXML(dtTmpList, "ScriptFormatMapping", "ReportType", "SP", 2);
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Denomination";
this.gvData.HeaderRow.Cells[3].Text = "Script Format";
this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
this.gvData.HeaderRow.Cells[5].Text = "Maker Date";
}
}
}
#endregion Script Mapping Certificate
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_POLICY).PadLeft(5, '0')))
{
#region SP Policy
lgText.InnerHtml = "SP Policy Approval Queue List";
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'SP Policy' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPPolicyDAL.LoadUnapprovedList(null, true);
if (oResult != null)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("CheckerID");
dtTmpList.Columns.Remove("CheckDate");
dtTmpList.Columns.Remove("CheckerComment");
dtTmpList.Columns.Remove("PolicyEffectDate");
dtTmpList.Columns.Remove("IsSPDurationInMonth");
dtTmpList.Columns.Remove("SPInterestType");
dtTmpList.Columns.Remove("InterestTypeAfterIntPayment");
dtTmpList.Columns.Remove("PreMaturityInterestType");
dtTmpList.Columns.Remove("PreMatIntTypeAfterIntPayment");
dtTmpList.Columns.Remove("IsNomineePerScripRequired");
dtTmpList.Columns.Remove("IsBondHolderRequired");
dtTmpList.Columns.Remove("IsFoeignAddressRequired");
dtTmpList.Columns.Remove("SupportedSex");
dtTmpList.Columns.Remove("PartiallyEncashable");
dtTmpList.Columns.Remove("ReinvestmentSuported");
dtTmpList.Columns.Remove("InterestReinvestable");
dtTmpList.Columns.Remove("PartiallyEncashedReinvestable");
dtTmpList.Columns.Remove("MaxNoOfReinvestment");
dtTmpList.Columns.Remove("NonOrgCommission");
dtTmpList.Columns.Remove("NonOrgCommissionType");
dtTmpList.Columns.Remove("OrgCommission");
dtTmpList.Columns.Remove("OrgCommissionType");
dtTmpList.Columns.Remove("Levi");
dtTmpList.Columns.Remove("LeviType");
dtTmpList.Columns.Remove("IncomeTax");
dtTmpList.Columns.Remove("IncomeTaxType");
dtTmpList.Columns.Remove("IncomeTaxApplyAmount");
dtTmpList.Columns.Remove("IncomeTaxYearlyYN");
dtTmpList.Columns.Remove("IsOrganizationLeviTax");
dtTmpList.Columns.Remove("InterestRemuneration");
dtTmpList.Columns.Remove("InterestRemunerationType");
dtTmpList.Columns.Remove("Remuneration");
dtTmpList.Columns.Remove("RemunerationType");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Policy ID";
this.gvData.HeaderRow.Cells[2].Text = "SP Type";
this.gvData.HeaderRow.Cells[3].Text = "SP Duration";
this.gvData.HeaderRow.Cells[4].Text = "No Of Coupons";
this.gvData.HeaderRow.Cells[5].Text = "Minimum Age";
this.gvData.HeaderRow.Cells[6].Text = "Maximum Age";
this.gvData.HeaderRow.Cells[7].Text = "Is Approved";
this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
this.gvData.HeaderRow.Cells[9].Text = "Make Date";
}
}
}
#endregion SP Policy
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_REPORT).PadLeft(5, '0')))
{
#region Report Mapping
lgText.InnerHtml = "Report Mapping Approval Queue List";
SPReportMappingDAL oSPReportMappingDAL = new SPReportMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Report Mapping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPReportMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
DataTable dtMappedData = null;
dtMappedData = DDListUtil.MapTableWithXML(dtTmpList, "ReportFormatMapping", "ReportType", "SS", 1);
dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "CC", 2);
dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "IC", 3);
dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "EC", 4);
gvData.DataSource = dtMappedData;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtMappedData;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet";
this.gvData.HeaderRow.Cells[3].Text = "Commission Claim";
this.gvData.HeaderRow.Cells[4].Text = "Interest Claim ";
this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim";
this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
this.gvData.HeaderRow.Cells[7].Text = "Maker Date";
}
}
}
#endregion Report Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_TYPE).PadLeft(5, '0')))
{
#region Sanchaya Patra Type
lgText.InnerHtml = "Sanchaya Patra Type Approval Queue List";
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Sanchaya Patra Type' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPTypeDAL.LoadTmpDataTableList();
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Type Description";
this.gvData.HeaderRow.Cells[3].Text = "Currency Code";
this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
this.gvData.HeaderRow.Cells[5].Text = "Make Date";
}
}
}
#endregion Sanchaya Patra Type
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_WISEA_CCOUNT).PadLeft(5, '0')))
{
#region Sanchaya Patra wise Account Mapping
lgText.InnerHtml = "Sanchaya Patra wise Account Mapping Approval Queue List";
SPTypeWiseAccountMappingDAL oSPTypeWiseAccountMappingDAL = new SPTypeWiseAccountMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Sanchaya Patra wise Account Mapping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPTypeWiseAccountMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
// for adding seperator....
alAddSeperatorIndex = new ArrayList();
alAddSeperatorIndex.Add(2);
alAddSeperatorIndex.Add(3);
alAddSeperatorIndex.Add(4);
alAddSeperatorIndex.Add(5);
alAddSeperatorIndex.Add(6);
alAddSeperatorIndex.Add(7);
dtTmpList.Columns.Remove("StockInHandAccName");
dtTmpList.Columns.Remove("LiabilityOnStockAccName");
dtTmpList.Columns.Remove("HoldingAccName");
dtTmpList.Columns.Remove("AccruedInterestAccName");
dtTmpList.Columns.Remove("AdvAgainstInterestAccName");
dtTmpList.Columns.Remove("AdvAgainstPrincipalAccName");
dtTmpList.Columns.Remove("CheckerID");
dtTmpList.Columns.Remove("CheckDate");
dtTmpList.Columns.Remove("CheckerComment");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SPType ID";
this.gvData.HeaderRow.Cells[2].Text = "Stock In Hand Acc";
this.gvData.HeaderRow.Cells[3].Text = "Liability On Stock Acc";
this.gvData.HeaderRow.Cells[4].Text = "Holding Acc";
this.gvData.HeaderRow.Cells[5].Text = "Accrued Interest Acc";
this.gvData.HeaderRow.Cells[6].Text = "AdvAgainst Interest Acc";
this.gvData.HeaderRow.Cells[7].Text = "Adv Against Principal Acc";
this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
this.gvData.HeaderRow.Cells[9].Text = "Make Date";
}
}
}
#endregion Sanchaya Patra wise Account Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SYSTEM_CONFIG).PadLeft(5, '0')))
{
#region System Configuration
lgText.InnerHtml = "System Configuration Approval Queue List";
SystemConfigurationDAL oSCDAL = new SystemConfigurationDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'System Configuration' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSCDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("Dr_Code");
dtTmpList.Columns.Remove("Cr_Code");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer Data File";
this.gvData.HeaderRow.Cells[2].Text = "Originator ID";
this.gvData.HeaderRow.Cells[3].Text = "Row Type Header";
this.gvData.HeaderRow.Cells[4].Text = "Row Type Footer";
this.gvData.HeaderRow.Cells[5].Text = "Dr Transaction Code";
this.gvData.HeaderRow.Cells[6].Text = "Cr Transaction Code";
this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
this.gvData.HeaderRow.Cells[8].Text = "Make Date";
}
}
}
#endregion System Configuration
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.COMMON_MAPPING).PadLeft(5, '0')))
{
#region Common Mapping
lgText.InnerHtml = "Common Mapping Approval Queue List";
CommonMappingDAL oCmAL = new CommonMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Common Mapping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCmAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
alAddSeperatorIndex = new ArrayList();
alAddSeperatorIndex.Add(3);
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
}
}
}
#endregion Common Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BANK).PadLeft(5, '0')))
{
#region Common Mapping
lgText.InnerHtml = "Bank Setup Approval Queue List";
BankDAL oBankDAL = new BankDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Bank Setup' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oBankDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
this.gvData.HeaderRow.Cells[1].Text = "Bank ID";
this.gvData.HeaderRow.Cells[2].Text = "BB Code";
this.gvData.HeaderRow.Cells[3].Text = "Bank Name";
this.gvData.HeaderRow.Cells[4].Text = "Branch ID";
this.gvData.HeaderRow.Cells[5].Text = "Address";
this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
this.gvData.HeaderRow.Cells[7].Text = "Make Date";
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
}
}
}
#endregion Common Mapping
}
}
}
public DataTable SelectAll()
{
BranchDAL dalBranch = new BranchDAL();
return(dalBranch.SelectAll());
}
protected void createButton_Click(object sender, EventArgs e)
{
User u = (User)Session["user"];
if (u == null)
{
Response.Write("<script>alert('invalid user 1.');window.opener=null;window.close();</script>");
return;
}
if (v == null)
{
Response.Write("<script>alert('invalid vid in create.');window.opener=null;window.close();</script>");
return;
}
if (u.user_id != v.user_id)
{
Response.Write("<script>alert('invalid user.');window.opener=null;window.close();</script>");
return;
}
if (name.Value.Length == 0 || desc.Value.Length == 0)
{
//error
Response.Write("<script>alert('invalid name or desc.');</script>");
return;
}
//new version
Version v2 = new Version();
v2.version_name = name.Value;
v2.description = desc.Value;
v2.prev_id = v.version_id; //!
v2.next_id = v.next_id; //!
v2.warehouse_id = v.warehouse_id;
v2.user_id = v.user_id;
v2.branch_id = v.branch_id;
if (!vd.Insert(ref v2))
{
Response.Write("<script>alert('insert error 1.');</script>");
return;
}
Version v3 = new Version();
v3.branch_id = v.branch_id;
v3.description = v.description;
v3.next_id = v2.version_id; //warning
v3.prev_id = v.prev_id; //warning
v3.timestamp = v.timestamp;
v3.user_id = v.user_id;
v3.version_id = v.version_id;
v3.version_name = v.version_name;
v3.warehouse_id = v.warehouse_id;
if (!vd.Update(ref v3))
{
Response.Write("<script>alert('error 3.');</script>");
vd.Delete(ref v2);
vd.Update(ref v);
return;
}
//create files
if (!FileSystem.CopyFolder(Server.MapPath("~/") + @"data\" + v.warehouse_id.ToString() + @"\" + v.version_id.ToString(), Server.MapPath("~/") + @"data\" + v.warehouse_id.ToString() + @"\" + v2.version_id.ToString()))
{
vd.Delete(ref v2);
vd.Update(ref v);
Response.Write("<script>alert('file error.');</script>");
return;
}
//warnning ; bug here
Branch b = new Branch();
b.branch_id = v.branch_id;
bd = new BranchDAL();
bd.SelectByID(ref b);
if (b.branch_name == "master")
{
Warehouse w = new Warehouse();
w.warehouse_id = v.warehouse_id;
wd = new WarehouseDAL();
wd.SelectedByID(ref w);
if (w.master_version_id == v.version_id)
{
w.master_version_id = v2.version_id;
wd.Update(ref w);
}
}
Response.Write("<script>alert('create success.');window.location.href='warehouse_page.aspx?wid=" + v.warehouse_id + "&vid=" + v2.version_id + "';</script>");
}
public BranchENT SelectByPK(SqlInt32 BranchID)
{
BranchDAL dalBranch = new BranchDAL();
return(dalBranch.SelectByPK(BranchID));
}
public DataTable SelectDropDownList()
{
BranchDAL dalBranch = new BranchDAL();
return(dalBranch.SelectDropDownList());
}
