public static List <ChampeignCharge> GetAll(int CID)
{
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
List <ChampeignCharge> ListTmp = new List <ChampeignCharge>();
string Query = "SELECT * FROM CustWallet where CID=" + CID.ToString();
try
{
cmd = new SqlCommand(Query, dBCon.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
int index = 0;
ChampeignCharge ObjTmp = new ChampeignCharge();
ObjTmp.ChargeId = SDR.GetInt32(index++);
ObjTmp.ChargeAmt = SDR.GetDouble(index++);
ObjTmp.OID = SDR.GetInt64(index++);
ObjTmp.CashBkId = SDR.GetInt32(index++);
ObjTmp.CreateDate = SDR.GetDateTime(index++);
ObjTmp.OrgId = SDR.GetInt32(index++);
ListTmp.Add(ObjTmp);
}
}
catch (Exception e) { e.ToString(); }
finally { dBCon.Close(); }
return(ListTmp);
}
public static int ChargeCamp(Int64 OID, int CBID, int OrgId)
{
if (CBID > 0)
{
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
var chargeAmt = new Settings().GetOne("CBCHARGE");
ChampeignCharge champeignCharge = new ChampeignCharge();
champeignCharge.ChargeAmt = double.Parse(chargeAmt.KeyValue);
champeignCharge.CashBkId = CBID;
champeignCharge.OID = OID;
champeignCharge.OrgId = OrgId;
champeignCharge.CreateDate = DateTime.Now;
double AvailableAmt = ObjOrg.WalletAmt - champeignCharge.ChargeAmt;
champeignCharge.BalanceAmt = AvailableAmt;
champeignCharge.Save();
ObjOrg.WalletAmt = AvailableAmt;
ObjOrg.Save();
return(champeignCharge.ChargeId);
}
return(0);
}