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