public static A2ZACCNOMINEEDTO GetInformation(int NomNo, Int16 acctype, int MemNo, Int64 AccNo, Int16 CuType, int CuNo)
{
var prm = new object[6];
prm[0] = NomNo;
prm[1] = acctype;
prm[2] = MemNo;
prm[3] = AccNo;
prm[4] = CuType;
prm[5] = CuNo;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoAccNominee", prm, "A2ZCSMCUS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCNOM WHERE NomNo = '" + NomNo + "' and AccType='" +
// acctype + "' and MemNo='" + MemNo + "' and AccNo='" + AccNo + "' and CuType='" + CuType + "' and CuNo='" + CuNo + "'", "A2ZCSMCUS");
var p = new A2ZACCNOMINEEDTO();
if (dt.Rows.Count > 0)
{
p.CuType = Converter.GetSmallInteger(dt.Rows[0]["CuType"]);
p.CUnionNo = Converter.GetInteger(dt.Rows[0]["CuNo"]);
p.MemberNo = Converter.GetInteger(dt.Rows[0]["MemNo"]);
p.AccType = Converter.GetSmallInteger(dt.Rows[0]["AccType"]);
p.AccountNo = Converter.GetLong(dt.Rows[0]["AccNo"]);
p.NomineeNo = Converter.GetInteger(dt.Rows[0]["NomNo"]);
p.NomineeName = Converter.GetString(dt.Rows[0]["NomName"]);
p.NomAddress1 = Converter.GetString(dt.Rows[0]["NomAdd1"]);
p.NomAddress2 = Converter.GetString(dt.Rows[0]["NomAdd2"]);
p.NomAddress3 = Converter.GetString(dt.Rows[0]["NomAdd3"]);
p.NomTelephoneNo = Converter.GetString(dt.Rows[0]["NomTel"]);
p.NomMobileNo = Converter.GetString(dt.Rows[0]["NomMobile"]);
p.NomEmail = Converter.GetString(dt.Rows[0]["NomEmail"]);
p.NomDivision = Converter.GetInteger(dt.Rows[0]["NomDivi"]);
p.NomDistrict = Converter.GetInteger(dt.Rows[0]["NomDist"]);
p.NomUpzila = Converter.GetInteger(dt.Rows[0]["NomUpzila"]);
p.NomThana = Converter.GetInteger(dt.Rows[0]["NomThana"]);
p.NomRelation = Converter.GetString(dt.Rows[0]["NomRela"]);
p.NomSharePercentage = Converter.GetInteger(dt.Rows[0]["NomSharePer"]);
p.Record = 1;
return(p);
}
p.NomineeNo = 0;
p.Record = 0;
return(p);
}
public static int InsertInformation(A2ZACCNOMINEEDTO dto)
{
int rowEffect = 0;
string strQuery = @"INSERT into A2ZACCNOM(BranchNo,MemType,MemNo,AccType,AccNo,NomNo,NomName,NomAdd1,NomAdd2,NomAdd3,NomTel,
NomMobile,NomEmail,NomDivi,NomDist,NomUpzila,NomThana,NomRela,NomSharePer) values('" + dto.BranchNo + "','" + dto.MemType + "','" + dto.MemberNo + "','" +
dto.AccType + "','" + dto.AccountNo + "','" + dto.NomineeNo + "','" + dto.NomineeName + "','" + dto.NomAddress1 + "','" +
dto.NomAddress2 + "','" + dto.NomAddress3 + "','" + dto.NomTelephoneNo + "','" + dto.NomMobileNo + "','" + dto.NomEmail + "','" +
dto.NomDivision + "','" + dto.NomDistrict + "','" + dto.NomUpzila + "','" + dto.NomThana + "','" + dto.NomRelation + "','" + dto.NomSharePercentage + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static int WFUpdateInformation(A2ZACCNOMINEEDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE WFCSA2ZACCNOM set BranchNo='" + dto.BranchNo + "',NomNo='" + dto.NomineeNo + "', NomName='" + dto.NomineeName +
"', NomAdd1='" + dto.NomAddress1 + "', NomAdd2='" + dto.NomAddress2 + "',NomAdd3='" + dto.NomAddress3 +
"',NomTel='" + dto.NomTelephoneNo + "',NomMobile='" + dto.NomMobileNo + "',NomEmail='" + dto.NomEmail +
"',NomDivi='" + dto.NomDivision + "',NomDist='" + dto.NomDistrict + "',NomUpzila='" + dto.NomUpzila +
"',NomThana='" + dto.NomThana +
"',NomRela='" + dto.NomRelation + "',NomSharePer='" + dto.NomSharePercentage + "'where Id='" + dto.ID + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static int UpdateInformation(A2ZACCNOMINEEDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZACCNOM set NomNo='" + dto.NomineeNo + "', NomName='" + dto.NomineeName +
"', NomAdd1='" + dto.NomAddress1 + "', NomAdd2='" + dto.NomAddress2 + "',NomAdd3='" + dto.NomAddress3 +
"',NomTel='" + dto.NomTelephoneNo + "',NomMobile='" + dto.NomMobileNo + "',NomEmail='" + dto.NomEmail +
"',NomDivi='" + dto.NomDivision + "',NomDist='" + dto.NomDistrict + "',NomUpzila='" + dto.NomUpzila +
"',NomThana='" + dto.NomThana +
"',NomRela='" + dto.NomRelation + "',NomSharePer='" + dto.NomSharePercentage + "'where NomNo='" + dto.NomineeNo +
"'and AccType='" + dto.AccType + "' and MemNo='" + dto.MemberNo + "' and AccNo='" + dto.AccountNo +
"' and CuType='" + dto.CuType + "' and CuNo='" + dto.CUnionNo + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static A2ZACCNOMINEEDTO WFGetInformation(int ID)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM WFCSA2ZACCNOM WHERE Id = '" + ID + "'", "A2ZCSCUBS");
var p = new A2ZACCNOMINEEDTO();
if (dt.Rows.Count > 0)
{
p.MemType = Converter.GetSmallInteger(dt.Rows[0]["MemType"]);
p.MemberNo = Converter.GetInteger(dt.Rows[0]["MemNo"]);
p.AccType = Converter.GetInteger(dt.Rows[0]["AccType"]);
p.AccountNo = Converter.GetLong(dt.Rows[0]["AccNo"]);
p.NomineeNo = Converter.GetInteger(dt.Rows[0]["NomNo"]);
p.NomineeName = Converter.GetString(dt.Rows[0]["NomName"]);
p.NomAddress1 = Converter.GetString(dt.Rows[0]["NomAdd1"]);
p.NomAddress2 = Converter.GetString(dt.Rows[0]["NomAdd2"]);
p.NomAddress3 = Converter.GetString(dt.Rows[0]["NomAdd3"]);
p.NomTelephoneNo = Converter.GetString(dt.Rows[0]["NomTel"]);
p.NomMobileNo = Converter.GetString(dt.Rows[0]["NomMobile"]);
p.NomEmail = Converter.GetString(dt.Rows[0]["NomEmail"]);
p.NomDivision = Converter.GetInteger(dt.Rows[0]["NomDivi"]);
p.NomDistrict = Converter.GetInteger(dt.Rows[0]["NomDist"]);
p.NomUpzila = Converter.GetInteger(dt.Rows[0]["NomUpzila"]);
p.NomThana = Converter.GetInteger(dt.Rows[0]["NomThana"]);
p.NomRelation = Converter.GetString(dt.Rows[0]["NomRela"]);
p.NomSharePercentage = Converter.GetInteger(dt.Rows[0]["NomSharePer"]);
p.UserId = Converter.GetInteger(dt.Rows[0]["UserId"]);
p.Record = 1;
return(p);
}
p.NomineeNo = 0;
p.Record = 0;
return(p);
}
