public Result <Donation> Save(Donation value)
{
var result = new Result <Donation>();
try
{
string query = "select * from Donation where ID=" + value.ID;
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
value.ID = GetID();
var date = Convert.ToDateTime(System.DateTime.Now);
query = "insert into Donation values(" + value.ID + ",SYSDATE,'" + value.Type + "'," + value.Amount + "," + value.PostID + "," + value.UserID + "," + value.Transaction + "," + value.Mobile + ")";
//query = "insert into Donation values(1,23-JAN-19,'Bkash',1000.0,3,4,547897,0987654567)";
}
result.HasError = DataAccess.ExecuteQuery(query) <= 0;
if (result.HasError)
{
result.Message = "Something Went Wrong";
return(result);
}
result.Data = value;
}
catch (Exception ex)
{
result.HasError = true;
result.Message = ex.Message;
}
return(result);
}
private Donation ConvertToEntity(DataRow row)
{
try
{
Donation u = new Donation();
u.ID = Int32.Parse(row["ID"].ToString());
u.PostID = Int32.Parse(row["POSTID"].ToString());
u.UserID = Int32.Parse(row["USERID"].ToString());
u.Amount = Int32.Parse(row["AMOUNT"].ToString());
u.Type = row["TYPE"].ToString();
u.DonateDate = Convert.ToDateTime(row["DONATEDATE"].ToString());
u.Mobile = Int32.Parse(row["MOBILE"].ToString());
u.Transaction = Int32.Parse(row["TRANSACTION"].ToString());
u.Email = row["Email"].ToString();
return(u);
}
catch (Exception ex)
{
return(null);
}
}
public List <Donation> GetByPostID(int pid)
{
var result = new List <Donation>();
try
{
string query = "select c.*,u.Email from Donation c,UserInfo u where c.UserID=u.ID and c.PostID=" + pid;
var dt = DataAccess.GetDataTable(query);
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Donation u = ConvertToEntity(dt.Rows[i]);
result.Add(u);
}
}
}
catch (Exception ex)
{
}
return(result);
}
