protected void BtnProceed_Click(object sender, EventArgs e)
{
CPSMEMBER();
string qry3 = "SELECT Id,MemNo,MemType FROM A2ZMEMBER ";
DataTable dt3 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry3, "A2ZCSMCUS");
if (dt3.Rows.Count > 0)
{
foreach (DataRow dr3 in dt3.Rows)
{
var ParentId = dr3["Id"].ToString();
var MemNo = dr3["MemNo"].ToString();
A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO();
objDTO.ID = Converter.GetSmallInteger(ParentId);
if (MemNo == "0")
{
objDTO.MemType = Converter.GetSmallInteger(1);
}
else
{
objDTO.MemType = Converter.GetSmallInteger(2);
}
int row2 = A2ZMEMBERDTO.Update2(objDTO);
}
}
}
protected void BtnProceed_Click(object sender, EventArgs e)
{
string sqlquery4 = "Truncate table dbo.A2ZMEMBER ";
int resultM = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlquery4, "A2ZCSMCUS"));
string qry = "SELECT CuType,CuNo FROM WFCUNO";
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 CuType = dr["CuType"].ToString();
var CuNo = dr["CuNo"].ToString();
SqlCommand cmd1 = new SqlCommand("INSERT INTO A2ZCSMCUS.dbo.A2ZMEMBER(CuType,CuNo,MemNo,MemName,MemOpenDate,MemOldCuNo,MemOldMemNo) SELECT MEMTYPE,CUNO,MEMNO,MEMNAME,MEMOPDT,CUNO,MEMNO FROM A2ZCCULB.dbo.A2ZMEMBER WHERE CUNO = '" + CuNo + "'", con);
con.Open();
int result2 = cmd1.ExecuteNonQuery();
if (result2 > 0)
{
string strQuery = "UPDATE A2ZMEMBER SET CuType = '" + CuType + "' WHERE CuNo='" + CuNo + "' ";
int rowEffect = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
Successful();
}
con.Close();
}
}
OLDLASTMEMBERNO();
OLDMEMBER();
OLD5000LASTMEMBERNO();
OLD5000MEMBER();
AddStaffMemberUpd();
CPSMEMBER();
string qry3 = "SELECT Id,MemNo,MemType FROM A2ZMEMBER ";
DataTable dt3 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry3, "A2ZCSMCUS");
if (dt3.Rows.Count > 0)
{
foreach (DataRow dr3 in dt3.Rows)
{
var ParentId = dr3["Id"].ToString();
var MemNo = dr3["MemNo"].ToString();
A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO();
objDTO.ID = Converter.GetSmallInteger(ParentId);
if (MemNo == "0")
{
objDTO.MemType = Converter.GetSmallInteger(1);
}
else
{
objDTO.MemType = Converter.GetSmallInteger(2);
}
int row2 = A2ZMEMBERDTO.Update2(objDTO);
}
}
string strQry = "DELETE A2ZMEMBER WHERE CuType= 3 AND CuNo = 534 AND MemNo = 1 AND MemOldMemNo = 1";
int rowEff = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(strQry, "A2ZCSMCUS"));
}
