public static int InsertInformation(A2ZPARTYDTO dto)
{
int rowEffect = 0;
var prm = new object[9];
prm[0] = dto.GroupCode;
prm[1] = dto.GroupName;
prm[2] = dto.PartyCode;
prm[3] = dto.PartyName;
prm[4] = dto.PartyAddresssLine1;
prm[5] = dto.PartyAddresssLine2;
prm[6] = dto.PartyAddresssLine3;
prm[7] = dto.PartyMobileNo;
prm[8] = dto.PartyEmail;
int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_InsertParty", prm, "A2ZACOMS"));
if (result == 0)
{
rowEffect = 1;
}
else
{
rowEffect = 0;
}
return(rowEffect);
}
public static A2ZPARTYDTO GetPartyInformation(int PartyCode)
{
var prm = new object[1];
prm[0] = PartyCode;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_GetPartyInformation", prm, "A2ZACOMS");
var p = new A2ZPARTYDTO();
if (dt.Rows.Count > 0)
{
p.GroupCode = Converter.GetInteger(dt.Rows[0]["GroupCode"]);
p.GroupName = Converter.GetString(dt.Rows[0]["GroupName"]);
p.PartyCode = Converter.GetInteger(dt.Rows[0]["PartyCode"]);
p.PartyName = Converter.GetString(dt.Rows[0]["PartyName"]);
p.PartyAddresssLine1 = Converter.GetString(dt.Rows[0]["PartyAddresssLine1"]);
p.PartyAddresssLine2 = Converter.GetString(dt.Rows[0]["PartyAddresssLine2"]);
p.PartyAddresssLine3 = Converter.GetString(dt.Rows[0]["PartyAddresssLine3"]);
p.PartyMobileNo = Converter.GetString(dt.Rows[0]["PartyMobileNo"]);
p.PartyEmail = Converter.GetString(dt.Rows[0]["PartyEmail"]);
return(p);
}
else
{
p.PartyCode = 0;
}
return(p);
}
public static int UpdateParty(A2ZPARTYDTO dto)
{
int rowEffect = 0;
var prm = new object[12];
prm[0] = dto.GroupCode;
prm[1] = dto.GroupName;
prm[2] = dto.PartyCode;
prm[3] = dto.PartyName;
prm[4] = dto.PartyAccNo;
prm[5] = dto.PartyAddresssLine1;
prm[6] = dto.PartyAddresssLine2;
prm[7] = dto.PartyAddresssLine3;
prm[8] = dto.PartyMobileNo;
prm[9] = dto.PartyEmail;
prm[10] = dto.PartyCurrencyCode;
prm[11] = dto.PartyCarringRate;
int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_UpdatePartyInfo", prm, "A2ZACGMS"));
if (result == 0)
{
rowEffect = 1;
}
else
{
rowEffect = 0;
}
return(rowEffect);
}
public static A2ZPARTYDTO GetAllLoanParty()
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySp("Sp_GetPartyInfo", "A2ZACWMS");
var p = new A2ZPARTYDTO();
if (dt.Rows.Count > 0)
{
p.PartyName = Converter.GetString(dt.Rows[0]["PartyName"]);
p.PartyAddresss = Converter.GetString(dt.Rows[0]["PartyAddresss"]);
p.PartyMobileNo = Converter.GetString(dt.Rows[0]["PartyMobileNo"]);
p.PartyEmail = Converter.GetString(dt.Rows[0]["PartyEmail"]);
return(p);
}
return(p);
}
public static A2ZPARTYDTO GetAccNoInformation(Int64 AccNo)
{
DataTable dt = new DataTable();
string strQuery = "SELECT * FROM A2ZPARTYCODE WHERE PartyAccNo='" + AccNo + "'";
dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZACWMS");
var p = new A2ZPARTYDTO();
if (dt.Rows.Count > 0)
{
p.PartyCode = Converter.GetInteger(dt.Rows[0]["PartyCode"]);
return(p);
}
p.PartyCode = 0;
return(p);
}
