protected void BtnProceed_Click(object sender, EventArgs e)
{
string sqlquery3 = "Truncate table dbo.A2ZCUNION ";
// string sqlquery4 = "Truncate table dbo.A2ZMEMBER ";
int result = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlquery3, "A2ZCSMCUS"));
// int resultM = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlquery4, "A2ZCSMCUS"));
SqlCommand cmd = new SqlCommand("INSERT INTO A2ZCSMCUS.dbo.A2ZCUNION(CuOldCuNo,CuName,CuOpDt,CuFlag,CuType,CuCertNo,CuAddL1,CuAddL2,CuAddL3,CuEmail,CuTel,CuMobile,CuFax,CuDivi,CuDist,CuThana,GLCashCode) SELECT CUNO,CUNAME,CUOPDT,CUMEMFLAG,CUTYPE,CUCERTNO,CUADDL1,CUADDL2,CUADDL3,CUEMAIL,CUTEL,CUMOBILE,CUFAX,CUDIVI,CUDIST,CUTHAN,GLCASHCODE FROM A2ZCCULB.dbo.A2ZCRUNION", con);
// SqlCommand cmd1 = new SqlCommand("INSERT INTO A2ZCSMCUS.dbo.A2ZMEMBER(CuType,CuNo,MemName,MemOpenDate) SELECT CUTYPE,CUNO,CUNAME,CUOPDT FROM A2ZCCULB.dbo.A2ZCRUNION", con);
con.Open();
int result1 = cmd.ExecuteNonQuery();
// int result2 = cmd1.ExecuteNonQuery();
if (result1 > 0)
{
Successful();
}
string qry = "SELECT Id,CuType,CuNo,CuName,CuOpDt FROM A2ZCUNION ";
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
int totrec = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var ParentId = dr["Id"].ToString();
//if (ParentId <= totrec.text)
//{
var CType = dr["CuType"].ToString();
var CNo = dr["CuNo"].ToString();
var CName = dr["CuName"].ToString();
var COpDt = dr["CuOpDt"].ToString();
int a = Converter.GetSmallInteger(CType);
int b = Converter.GetSmallInteger(CNo);
A2ZCUNIONDTO objDTO = new A2ZCUNIONDTO();
objDTO.ID = Converter.GetSmallInteger(ParentId);
if (CType == "0")
{
objDTO.CuType = 1;
objDTO.CuTypeName = "Affiliate";
}
else if (CType == "1")
{
objDTO.CuType = 2;
objDTO.CuTypeName = "Associate";
}
else if (CType == "2")
{
objDTO.CuType = 3;
objDTO.CuTypeName = "Regular";
}
objDTO.CuProcFlag = 13;
if (COpDt == "")
{
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
string strQuery = "UPDATE A2ZCUNION set CuOpDt='" + dto.ProcessDate + "' where Id='" + objDTO.ID + "' ";
int rowEffect = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
if (rowEffect > 0)
{
DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery("SELECT CuOpDt FROM A2ZCUNION WHERE Id='" + objDTO.ID + "'", "A2ZCSMCUS");
if (dt1.Rows.Count > 0)
{
var OpDt1 = Converter.GetString(dt1.Rows[0]["CuOpDt"]);
objDTO.CuStatusDate = Converter.GetDateTime(OpDt1);
objDTO.InputByDate = Converter.GetDateTime(OpDt1);
objDTO.VerifyByDate = Converter.GetDateTime(OpDt1);
objDTO.ApprovByDate = Converter.GetDateTime(OpDt1);
}
}
}
else
{
objDTO.CuStatusDate = Converter.GetDateTime(COpDt);
objDTO.InputByDate = Converter.GetDateTime(COpDt);
objDTO.VerifyByDate = Converter.GetDateTime(COpDt);
objDTO.ApprovByDate = Converter.GetDateTime(COpDt);
}
int row = A2ZCUNIONDTO.UpdateInformation1(objDTO);
if (row > 0)
{
}
Int16 rcytype = Converter.GetSmallInteger(objDTO.CuType);
A2ZRECCTRLDTO RDTO = (A2ZRECCTRLDTO.GetLastRecords(rcytype));
objDTO.CreditUnionNo = Converter.GetSmallInteger(RDTO.CtrlRecLastNo);
int row1 = A2ZCUNIONDTO.UpdateInformation1(objDTO);
if (row1 > 0)
{
// A2ZMEMBERDTO MemDTO = new A2ZMEMBERDTO();
// MemDTO.MemberNo = 0;
// MemDTO.ID = Converter.GetSmallInteger(objDTO.ID);
// MemDTO.CuType = Converter.GetSmallInteger(objDTO.CuType);
// MemDTO.CreditUnionNo = Converter.GetInteger(objDTO.CreditUnionNo);
// MemDTO.MemberName = Converter.GetString(CName);
// int row2 = A2ZMEMBERDTO.Update(MemDTO);
}
}
}
GLCashCode();
}