public void Delete(long donorId, ref IAuctionTransaction trans) { using(var donors = new DonorCollection()) { donors.DeleteMulti(new PredicateExpression {DonorFields.Id == donorId}); } }
public DSDonorCollection GetDonorCollectionData(DonorCollection d, string fromdate, string todate) { DSDonorCollection ds = new DSDonorCollection(); try { string Donors = ""; string all = ""; if (d.DonorName != null && d.DonorName != "") { Donors = "Select * from DonorCollection Where DonorName='" + d.DonorName + "' and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#"; } else { all = "Select * from DonorCollection"; } con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); if (con.State == ConnectionState.Open) { string select = ""; if (d.DonorName != null && d.DonorName != "") { select = Donors; } else { select = all; } da = new OleDbDataAdapter(select, con); da.Fill(ds, ds.Tables[0].TableName); } return(ds); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public Auction.Domain.Donor GetDonor(long Id, ref IAuctionTransaction trans) { using (var donors = new DonorCollection()) { donors.GetMulti(new PredicateExpression { DonorFields.Id == Id }, 1); return donors.Select(d => new Donor() { Id = d.Id, AccountId = d.AccountId, Name = d.Name, Notes = d.Notes, Phone = d.Phone }).First(); } }
public IList<Auction.Domain.Donor> GetByAccount(long accountId, ref IAuctionTransaction trans) { using (var donors = new DonorCollection()) { var filter = new PredicateExpression { DonorFields.AccountId == accountId }; donors.GetMulti(filter); return donors.Select(d => new Donor() { Id = d.Id, AccountId = d.AccountId, Name = d.Name, Notes = d.Notes, Phone = d.Phone }).ToList(); } }
public List<DonorCollection> GetDonorCollectionData() { try { Donorcollc = new List<DonorCollection>(); string insert = "Select * from DonorCollection"; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(insert, con); cmd.Transaction = tran; dr = cmd.ExecuteReader(); while (dr.Read()) { DonorCollection m = new DonorCollection(); m.ID = dr["ID"] == System.DBNull.Value ? 0 : Convert.ToInt32(dr["ID"]); m.DonorName = dr["DonorName"] == System.DBNull.Value ? null : Convert.ToString(dr["DonorName"]); m.CollectionDate = dr["CollectionDate"] == System.DBNull.Value ? new DateTime() : Convert.ToDateTime(dr["CollectionDate"]); m.CollectionFee = dr["CollectionFee"] == System.DBNull.Value ? 0 : Convert.ToDecimal(dr["CollectionFee"]); m.ReciptNo = dr["ReciptNo"] == System.DBNull.Value ? 0 : Convert.ToDecimal(dr["ReciptNo"]); m.DonationType = dr["DonationType"] == System.DBNull.Value ? null : Convert.ToString(dr["DonationType"]); m.Others = dr["Other"] == System.DBNull.Value ? null : Convert.ToString(dr["Other"]); m.CheckDetail = dr["CheckDetail"] == System.DBNull.Value ? 0 : Convert.ToDecimal(dr["CheckDetail"]); Donorcollc.Add(m); } dr.Close(); tran.Commit(); return Donorcollc; } catch (Exception ex) { throw ex; } }
public IList<Auction.Domain.Donor> GetByEvent(long eventId, ref IAuctionTransaction trans) { using (var donors = new DonorCollection()) { var relations = new RelationCollection {AuctionEventDonorEntity.Relations.DonorEntityUsingDonorId}; var filter = new PredicateExpression { AuctionEventDonorFields.EventId == eventId }; donors.GetMulti(filter, relations); return donors.Select(d => new Donor() { Id = d.Id, AccountId = d.AccountId, Name = d.Name, Notes = d.Notes, Phone = d.Phone }).ToList(); } }
public void Save() { try { DC = new DonorCollection(); DC.CollectionDate = dtpCollectionDate.Value.Date; DC.DonorName = cbxName.Text.Trim(); Decimal colfee; Decimal.TryParse(this.txtCollectionfee.Text, out colfee); DC.CollectionFee = colfee; Decimal recno; Decimal.TryParse(this.txtReciptNo.Text, out recno); DC.ReciptNo = recno; Decimal chkdetail; Decimal.TryParse(this.txtCheckDetails.Text, out chkdetail); DC.CheckDetail = chkdetail; DC.DonationType = cbxDonationtype.Text.Trim(); DC.Others = txtOtherDonation.Text.Trim(); if (frm.CurrentCollection != null) { DC.ID = frm.CurrentCollection.ID; } if (new DonorBLL().SaveDonorCollection(DC)) { MessageBox.Show("Donor Collection Saved Successfully"); } ClearControll(); } catch (Exception ex) { throw ex; } }
public bool SaveDonorCollection(DonorCollection mc) { try { string insert; if (mc.ID == 0) insert = "Insert Into DonorCollection(DonorName,CollectionDate,CollectionFee,ReciptNo,DonationType,Other,CheckDetail) " + "values ('" + mc.DonorName + "',#" + mc.CollectionDate + "#," + mc.CollectionFee + "," + mc.ReciptNo + ",'" + mc.DonationType + "','" + mc.Others + "'," + mc.CheckDetail + " )"; else insert = "Update DonorCollection set DonorName='" + mc.DonorName + "',CollectionDate=#" + mc.CollectionDate + "#,CollectionFee=" + mc.CollectionFee + " ,ReciptNo=" + mc.ReciptNo + ",DonationType='" + mc.DonationType + "',Other='" + mc.Others + "',CheckDetail="+mc.CheckDetail+" where ID=" + mc.ID + ""; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(insert, con); cmd.Transaction = tran; cmd.ExecuteNonQuery(); tran.Commit(); return true; } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public DSDonorCollection GetDonorCollectionData(DonorCollection d, string Fromdate, string Todate, bool All) { return(new DonorDAL().GetDonorCollectionData(d, Fromdate, Todate, All)); }
public bool DeleteDonorCollection(DonorCollection mem) { return(new DonorDAL().DeleteDonorCollection(mem)); }
public bool SaveDonorCollection(DonorCollection mem) { return(new DonorDAL().SaveDonorCollection(mem)); }
public IList<Auction.Domain.Donor> GetDonors(IEnumerable<long> ids, ref IAuctionTransaction trans) { using(var donors = new DonorCollection()) { donors.GetMulti(new PredicateExpression {DonorFields.Id == ids.ToArray()}); return donors.Select(d => new Donor() { Id = d.Id, AccountId = d.AccountId, Name = d.Name, Notes = d.Notes, Phone = d.Phone }).ToList(); } }
public void Update(ref Auction.Domain.Donor donor, ref IAuctionTransaction trans) { var d = new DonorEntity { Notes = donor.Notes, Name = donor.Name, AccountId = donor.AccountId, Phone = donor.Phone, UpdatedBy = donor.UpdatedBy }; using (var donors = new DonorCollection()) { donors.UpdateMulti(d, new PredicateExpression {DonorFields.Id == donor.Id}); } }