protected void BtnInput_Click1(object sender, EventArgs e)
{
try
{
Button b = (Button)sender;
GridViewRow r = (GridViewRow)b.NamingContainer;
Label CTyNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[3].FindControl("lblcutype");
Label CrNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[4].FindControl("lblcno");
int a = Converter.GetSmallInteger(CTyNo.Text);
int c = Converter.GetSmallInteger(CrNo.Text);
Int16 CuType = Converter.GetSmallInteger(a);
int CNo = Converter.GetSmallInteger(c);
A2ZCUAPPLICATIONDTO objDTO = (A2ZCUAPPLICATIONDTO.GetInformation(CuType, CNo));
objDTO.CuType = CuType;
objDTO.CreditUnionNo = CNo;
if (objDTO.CuProcFlag == 8)
{
objDTO.CuProcFlag = Converter.GetSmallInteger(11);
objDTO.CuProcDesc = "Input";
}
if (objDTO.CuProcFlag == 10)
{
objDTO.CuProcFlag = Converter.GetSmallInteger(21);
objDTO.CuProcDesc = "ReEdited";
}
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
objDTO.VerifyByDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate);
int roweffect = A2ZCUAPPLICATIONDTO.UpdateInformation2(objDTO);
if (roweffect > 0)
{
gvVerify();
string CheckQuery = "SELECT CuType,CuTypeName,CuNo,CuName,CuOpDt,CuProcDesc FROM A2ZCUAPPLICATION Where CuProcFlag BETWEEN 8 AND 10 and CuStatus !='99'";
DataTable dt = new DataTable();
dt = CommonManager.Instance.GetDataTableByQuery(CheckQuery, "A2ZCSMCUS");
if (dt.Rows.Count <= 0)
{
DivGridViewCancle.Visible = false;
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnInput_Click1 Problem');</script>");
//throw ex;
}
}
protected void BtnVerify_Click(object sender, EventArgs e)
{
Button b = (Button)sender;
GridViewRow r = (GridViewRow)b.NamingContainer;
Label CTyNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[4].FindControl("lblcutype");
Label CrNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[5].FindControl("lblcno");
int a = Converter.GetSmallInteger(CTyNo.Text);
int c = Converter.GetSmallInteger(CrNo.Text);
Int16 CuType = Converter.GetSmallInteger(a);
int CNo = Converter.GetSmallInteger(c);
A2ZCUAPPLICATIONDTO objDTO = (A2ZCUAPPLICATIONDTO.GetInformation(CuType, CNo));
objDTO.CuType = CuType;
objDTO.CreditUnionNo = CNo;
if (objDTO.CuProcFlag == 21)
{
objDTO.CuProcFlag = Converter.GetSmallInteger(22);
objDTO.CuProcDesc = "ReVerified";
}
else
{
objDTO.CuProcFlag = Converter.GetSmallInteger(12);
objDTO.CuProcDesc = "Verified";
}
objDTO.VerifyBy = Converter.GetSmallInteger(SessionStore.GetValue(Params.SYS_USER_ID));
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
objDTO.VerifyByDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate);
int roweffect = A2ZCUAPPLICATIONDTO.UpdateInformation2(objDTO);
if (roweffect > 0)
{
gvVerify();
string CheckQuery = "SELECT CuType,CuTypeName,CuNo,CuName,CuOpDt,CuProcDesc FROM A2ZCUAPPLICATION Where CuProcFlag = '11' OR CuProcFlag = '21' OR CuProcFlag = '31' and CuStatus !='99'";
DataTable dt = new DataTable();
dt = CommonManager.Instance.GetDataTableByQuery(CheckQuery, "A2ZCSMCUS");
if (dt.Rows.Count <= 0)
{
DivGridViewCancle.Visible = false;
lblmsg1.Visible = true;
lblmsg2.Visible = true;
}
}
}
protected void BtnApprove_Click(object sender, EventArgs e)
{
try
{
A2ZRECCTRLDTO getDTO = (A2ZRECCTRLDTO.GetLastRecords(1));
lblNewSRL.Text = Converter.GetString(getDTO.CtrlRecLastNo);
A2ZCUNIONDTO MemDTO = new A2ZCUNIONDTO();
A2ZMEMBERDTO Mem1DTO = new A2ZMEMBERDTO();
A2ZACCOUNTDTO Mem2DTO = new A2ZACCOUNTDTO();
Button b = (Button)sender;
GridViewRow r = (GridViewRow)b.NamingContainer;
Label CTyNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[5].FindControl("lblcutype");
Label CrNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[6].FindControl("lblcno");
int a = Converter.GetSmallInteger(CTyNo.Text);
int c = Converter.GetSmallInteger(CrNo.Text);
Int16 CuType = Converter.GetSmallInteger(a);
int CNo = Converter.GetSmallInteger(c);
lblCuType.Text = Converter.GetString(CuType);
lblCuNo.Text = Converter.GetString(CNo);
A2ZCUAPPLICATIONDTO objDTO = (A2ZCUAPPLICATIONDTO.GetInformation(CuType, CNo));
if (objDTO.CreditUnionNo > 0)
{
objDTO.CuType = CuType;
objDTO.CreditUnionNo = CNo;
MemDTO.CuType = Converter.GetSmallInteger(objDTO.CuType);
MemDTO.CuTypeName = Converter.GetString(objDTO.CuTypeName);
MemDTO.CreditUnionNo = Converter.GetInteger(lblNewSRL.Text);
MemDTO.CreditUnionName = Converter.GetString(objDTO.CreditUnionName);
MemDTO.opendate = Converter.GetDateTime(objDTO.opendate);
MemDTO.MemberFlag = Converter.GetSmallInteger(objDTO.MemberFlag);
MemDTO.CertificateNo = Converter.GetInteger(objDTO.CertificateNo);
MemDTO.AddressL1 = Converter.GetString(objDTO.AddressL1);
MemDTO.AddressL2 = Converter.GetString(objDTO.AddressL2);
MemDTO.AddressL3 = Converter.GetString(objDTO.AddressL3);
MemDTO.TelephoneNo = Converter.GetString(objDTO.TelephoneNo);
MemDTO.MobileNo = Converter.GetString(objDTO.MobileNo);
MemDTO.Fax = Converter.GetString(objDTO.Fax);
MemDTO.email = Converter.GetString(objDTO.email);
MemDTO.Division = Converter.GetInteger(objDTO.Division);
MemDTO.District = Converter.GetInteger(objDTO.District);
MemDTO.Upzila = Converter.GetInteger(objDTO.Upzila);
MemDTO.Thana = Converter.GetInteger(objDTO.Thana);
MemDTO.GLCashCode = Converter.GetInteger(objDTO.GLCashCode);
MemDTO.CuStatusDate = Converter.GetDateTime(objDTO.CuStatusDate);
MemDTO.ValueDate = Converter.GetDateTime(objDTO.ValueDate);
MemDTO.CreateDate = Converter.GetDateTime(objDTO.CreateDate);
objDTO.CuProcFlag = Converter.GetSmallInteger(13);
objDTO.CuProcDesc = "Approved";
objDTO.ApprovBy = Converter.GetSmallInteger(SessionStore.GetValue(Params.SYS_USER_ID));
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
objDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate);
MemDTO.CuProcFlag = Converter.GetSmallInteger(objDTO.CuProcFlag);
MemDTO.ApprovBy = Converter.GetSmallInteger(objDTO.ApprovBy);
MemDTO.ApprovByDate = Converter.GetDateTime(objDTO.ApprovByDate);
MemDTO.InputBy = Converter.GetSmallInteger(objDTO.InputBy);
MemDTO.VerifyBy = Converter.GetSmallInteger(objDTO.VerifyBy);
MemDTO.InputByDate = Converter.GetDateTime(objDTO.InputByDate);
MemDTO.VerifyByDate = Converter.GetDateTime(objDTO.VerifyByDate);
objDTO.VerifyBy = Converter.GetSmallInteger(MemDTO.VerifyBy);
objDTO.VerifyByDate = Converter.GetDateTime(MemDTO.VerifyByDate);
Mem1DTO.CuType = Converter.GetSmallInteger(MemDTO.CuType);
Mem1DTO.CreditUnionNo = Converter.GetInteger(MemDTO.CreditUnionNo);
Mem1DTO.MemberName = Converter.GetString(MemDTO.CreditUnionName);
Mem1DTO.OpenDate = Converter.GetDateTime(MemDTO.opendate);
Mem1DTO.MemType = 1;
Mem2DTO.CuType = Converter.GetSmallInteger(MemDTO.CuType);
Mem2DTO.CuNo = Converter.GetInteger(MemDTO.CreditUnionNo);
Mem2DTO.AccType = 99;
Mem2DTO.AccNo = 0;
Mem2DTO.MemberNo = 0;
Mem2DTO.Opendate = Converter.GetDateTime(MemDTO.opendate);
Mem2DTO.AccStatus = 1;
Mem2DTO.AccAtyClass = 6;
int roweffect = A2ZCUAPPLICATIONDTO.UpdateInformation2(objDTO);
if (roweffect > 0)
{
int row = A2ZCUNIONDTO.InsertInformation(MemDTO);
int row1 = A2ZMEMBERDTO.Insert(Mem1DTO);
InsertMiscRecord();
//int row2 = A2ZACCOUNTDTO.Insert(Mem2DTO);
DisplayMessage();
gvVerify();
string CheckQuery = "SELECT CuType,CuTypeName,CuNo,CuName,CuOpDt,CuProcDesc FROM A2ZCUAPPLICATION Where CuProcFlag = '12' OR CuProcFlag = '22' and CuStatus !='99'";
DataTable dt = new DataTable();
dt = CommonManager.Instance.GetDataTableByQuery(CheckQuery, "A2ZCSMCUS");
if (dt.Rows.Count <= 0)
{
DivGridViewCancle.Visible = false;
lblmsg1.Visible = true;
lblmsg2.Visible = true;
}
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnApprove_Click Problem');</script>");
//throw ex;
}
}
protected void BtnCreUnionUpdate_Click(object sender, EventArgs e)
{
try
{
A2ZCUAPPLICATIONDTO UpDTO = new A2ZCUAPPLICATIONDTO();
UpDTO.CuType = Converter.GetSmallInteger(lblCuType.Text);
UpDTO.CreditUnionNo = Converter.GetInteger(lblCuNo.Text);
UpDTO.CreditUnionName = Converter.GetString(txtCreUName.Text);
if (lblProcFlag.Text == "9")
{
UpDTO.CuProcFlag = Converter.GetSmallInteger(10);
UpDTO.CuProcDesc = "Edited";
}
else
{
UpDTO.CuProcFlag = Converter.GetSmallInteger(8);
UpDTO.CuProcDesc = "Input";
}
UpDTO.CuTypeName = Converter.GetString("Affiliate");
UpDTO.InputBy = Converter.GetSmallInteger(SessionStore.GetValue(Params.SYS_USER_ID));
if (txtCuOpenDate.Text != string.Empty)
{
DateTime opdate = DateTime.ParseExact(txtCuOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
UpDTO.opendate = opdate;
}
else
{
string CheckNullOpenDate = "";
UpDTO.NullOpenDate = CheckNullOpenDate;
}
//UpDTO.MemberFlag = Converter.GetSmallInteger(ddlCuMemberFlag.SelectedValue);
UpDTO.CertificateNo = Converter.GetInteger(txtCuCertificateNo.Text);
UpDTO.AddressL1 = Converter.GetString(txtCuAddressL1.Text);
UpDTO.AddressL2 = Converter.GetString(txtCuAddressL2.Text);
UpDTO.AddressL3 = Converter.GetString(txtCuAddressL3.Text);
UpDTO.TelephoneNo = Converter.GetString(txtCuTelNo.Text);
UpDTO.MobileNo = Converter.GetString(txtCuMobileNo.Text);
UpDTO.Fax = Converter.GetString(txtCuFax.Text);
UpDTO.email = Converter.GetString(txtCuEmail.Text);
UpDTO.Division = Converter.GetInteger(ddlDivision.SelectedValue);
UpDTO.District = Converter.GetInteger(ddlDistrict.SelectedValue);
UpDTO.Upzila = Converter.GetInteger(ddlUpzila.SelectedValue);
UpDTO.Thana = Converter.GetInteger(ddlThana.SelectedValue);
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
if (dto.ProcessDate == DateTime.MinValue)
{
string checkNullStatusDate = "";
UpDTO.NullStatusDate = checkNullStatusDate;
string checkNullInputByDate = "";
UpDTO.NullInputByDate = checkNullInputByDate;
string checkNullVerifyDate = "";
UpDTO.NullVerifyByDate = checkNullVerifyDate;
string checkNullApproveDate = "";
UpDTO.NullApprovByDate = checkNullApproveDate;
string checkNullValueDate = "";
UpDTO.NullValueDate = checkNullValueDate;
string checkNullCreateDate = "";
UpDTO.NullCreateDate = checkNullCreateDate;
}
else
{
UpDTO.CuStatusDate = Converter.GetDateTime(dto.ProcessDate);
UpDTO.InputByDate = Converter.GetDateTime(dto.ProcessDate);
UpDTO.VerifyByDate = Converter.GetDateTime(dto.ProcessDate);
UpDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate);
UpDTO.ValueDate = Converter.GetDateTime(dto.ProcessDate);
UpDTO.CreateDate = Converter.GetDateTime(dto.ProcessDate);
}
UpDTO.GLCashCode = Converter.GetInteger(txtGLCashCode.Text);
// int row = A2ZMEMBERDTO.Update(MemDTO);
int roweffect = A2ZCUAPPLICATIONDTO.UpdateInformation(UpDTO);
if (roweffect > 0)
{
BtnCreUnionSubmit.Visible = true;
BtnCreUnionUpdate.Visible = false;
//ddlCuMemberFlag.SelectedValue = "0";
clearInfo();
gvVerify();
string CheckQuery = "SELECT CuType,CuTypeName,CuNo,CuName,CuOpDt,CuProcDesc FROM A2ZCUAPPLICATION Where CuProcFlag BETWEEN 8 AND 10 and CuStatus !='99'";
DataTable dt = new DataTable();
dt = CommonManager.Instance.GetDataTableByQuery(CheckQuery, "A2ZCSMCUS");
if (dt.Rows.Count <= 0)
{
DivGridViewCancle.Visible = false;
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnCreUnionUpdate_Click Problem');</script>");
//throw ex;
}
}
protected void BtnReEdit_Click(object sender, EventArgs e)
{
try
{
Button b = (Button)sender;
GridViewRow r = (GridViewRow)b.NamingContainer;
Label CTyNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[3].FindControl("lblcutype");
Label CrNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[4].FindControl("lblcno");
int a = Converter.GetSmallInteger(CTyNo.Text);
int c = Converter.GetSmallInteger(CrNo.Text);
Int16 CuType = Converter.GetSmallInteger(a);
lblCuType.Text = Converter.GetString(a);
int CNo = Converter.GetSmallInteger(c);
lblCuNo.Text = Converter.GetString(c);
A2ZCUAPPLICATIONDTO getDTO = (A2ZCUAPPLICATIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
//txtCreditUNo.Text = Converter.GetString(getDTO.CreditUnionNo);
txtCreUName.Text = Converter.GetString(getDTO.CreditUnionName);
//ddlCreditUNo.SelectedValue = Converter.GetString(getDTO.CreditUnionNo);
DateTime dt = Converter.GetDateTime(getDTO.opendate);
string date = dt.ToString("dd/MM/yyyy");
txtCuOpenDate.Text = date;
//txtCuOpenDate.Text = Converter.GetString(getDTO.opendate);
//ddlCuMemberFlag.SelectedValue = Converter.GetString(getDTO.MemberFlag);
txtCuCertificateNo.Text = Converter.GetString(getDTO.CertificateNo);
txtGLCashCode.Text = Converter.GetString(getDTO.GLCashCode);
if (txtGLCashCode.Text != string.Empty && txtGLCashCode.Text != "0")
{
ddlGLCashCode.SelectedValue = Converter.GetString(getDTO.GLCashCode);
}
txtCuAddressL1.Text = Converter.GetString(getDTO.AddressL1);
txtCuAddressL2.Text = Converter.GetString(getDTO.AddressL2);
txtCuAddressL3.Text = Converter.GetString(getDTO.AddressL3);
txtCuTelNo.Text = Converter.GetString(getDTO.TelephoneNo);
txtCuMobileNo.Text = Converter.GetString(getDTO.MobileNo);
txtCuFax.Text = Converter.GetString(getDTO.Fax);
txtCuEmail.Text = Converter.GetString(getDTO.email);
ddlDivision.SelectedValue = Converter.GetString(getDTO.Division);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.District);
ddlUpzila.SelectedValue = Converter.GetString(getDTO.Upzila);
ddlThana.SelectedValue = Converter.GetString(getDTO.Thana);
lblProcFlag.Text = Converter.GetString(getDTO.CuProcFlag);
txtCreUName.Focus();
BtnCreUnionSubmit.Visible = false;
BtnCreUnionUpdate.Visible = true;
}
else
{
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnReEdit_Click Problem');</script>");
//throw ex;
}
}
protected void BtnCreUnionSubmit_Click(object sender, EventArgs e)
{
try
{
A2ZCUAPPLICATIONDTO objDTO = new A2ZCUAPPLICATIONDTO();
A2ZMEMBERDTO MemDTO = new A2ZMEMBERDTO();
A2ZRECCTRLDTO getDTO = (A2ZRECCTRLDTO.GetLastRecords(5));
MemDTO.CreditUnionNo = Converter.GetInteger(getDTO.CtrlRecLastNo);
objDTO.CreditUnionNo = Converter.GetInteger(getDTO.CtrlRecLastNo);
lblNewSRL.Text = Converter.GetString(getDTO.CtrlRecLastNo);
lblLastSRL.Text = Converter.GetString(getDTO.CtrlRecLastNo);
MemDTO.MemberName = Converter.GetString(txtCreUName.Text);
MemDTO.MemType = 1;
objDTO.CreditUnionName = Converter.GetString(txtCreUName.Text);
//DateTime date = DateTime.ParseExact(txtCuOpenDate.Text, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture);
if (txtCuOpenDate.Text != string.Empty)
{
DateTime opdate = DateTime.ParseExact(txtCuOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
objDTO.opendate = opdate;
MemDTO.OpenDate = opdate;
}
else
{
string CheckNullOpenDate = "";
objDTO.NullOpenDate = CheckNullOpenDate;
}
//objDTO.opendate = Converter.GetDateTime(System.DateTime.Now.ToLongDateString());
//objDTO.MemberFlag = Converter.GetSmallInteger(ddlCuMemberFlag.SelectedValue);
// objDTO.MemberType = Converter.GetSmallInteger(ddlCuMemberType.SelectedValue);
objDTO.CuType = 1;
objDTO.CuTypeName = Converter.GetString("Affiliate");
objDTO.CuProcFlag = 8;
objDTO.CuProcDesc = "Input";
objDTO.InputBy = Converter.GetSmallInteger(SessionStore.GetValue(Params.SYS_USER_ID));
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
if (dto.ProcessDate == DateTime.MinValue)
{
string checkNullStatusDate = "";
objDTO.NullStatusDate = checkNullStatusDate;
string checkNullInputByDate = "";
objDTO.NullInputByDate = checkNullInputByDate;
string checkNullVerifyDate = "";
objDTO.NullVerifyByDate = checkNullVerifyDate;
string checkNullApproveDate = "";
objDTO.NullApprovByDate = checkNullApproveDate;
string checkNullValueDate = "";
objDTO.NullValueDate = checkNullValueDate;
string checkNullCreateDate = "";
objDTO.NullCreateDate = checkNullCreateDate;
}
else
{
objDTO.CuStatusDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.InputByDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.VerifyByDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.ValueDate = Converter.GetDateTime(dto.ProcessDate);
objDTO.CreateDate = Converter.GetDateTime(dto.ProcessDate);
}
objDTO.CertificateNo = Converter.GetInteger(txtCuCertificateNo.Text);
objDTO.AddressL1 = Converter.GetString(txtCuAddressL1.Text);
objDTO.AddressL2 = Converter.GetString(txtCuAddressL2.Text);
objDTO.AddressL3 = Converter.GetString(txtCuAddressL3.Text);
objDTO.TelephoneNo = Converter.GetString(txtCuTelNo.Text);
objDTO.MobileNo = Converter.GetString(txtCuMobileNo.Text);
objDTO.Fax = Converter.GetString(txtCuFax.Text);
objDTO.email = Converter.GetString(txtCuEmail.Text);
objDTO.Division = Converter.GetInteger(ddlDivision.SelectedValue);
objDTO.District = Converter.GetInteger(ddlDistrict.SelectedValue);
objDTO.Upzila = Converter.GetInteger(ddlUpzila.SelectedValue);
objDTO.Thana = Converter.GetInteger(ddlThana.SelectedValue);
objDTO.GLCashCode = Converter.GetInteger(txtGLCashCode.Text);
// int row = A2ZMEMBERDTO.Insert(MemDTO);
int roweffect = A2ZCUAPPLICATIONDTO.InsertInformation(objDTO);
if (roweffect > 0)
{
//ddlCuMemberFlag.SelectedValue = "0";
// ddlCuMemberType.SelectedValue = "0";
clearInfo();
txtCreUName.Focus();
DisplayMessage();
gvVerify();
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnCreUnionSubmit_Click Problem');</script>");
//throw ex;
}
}
