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