public static Sponsor GetSponsorByID(int id, bool bringDetails = false) { Sponsor x = new Sponsor(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_ID_Sponsor", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@SponsorID", id); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.Read()) { if (!(rd["SponsorID"] is DBNull)) { x.SponsorID = int.Parse(rd["SponsorID"].ToString()); } x.Name = rd["Name"].ToString(); x.Nationality = rd["Nationality"].ToString(); if (!(rd["IsOrganazation"] is DBNull)) { x.IsOrganazation = bool.Parse(rd["IsOrganazation"].ToString()); } if (!(rd["DOB"] is DBNull)) { x.DOB = DateTime.Parse(rd["DOB"].ToString()); } x.Gender = rd["Gender"].ToString(); x.Phone = rd["Phone"].ToString(); x.Mobile = rd["Mobile"].ToString(); x.Email = rd["Email"].ToString(); x.Address = rd["Address"].ToString(); x.MainSponsorship = rd["MainSponsorship"].ToString(); x.MediatorName = rd["MediatorName"].ToString(); x.MediatorMobile = rd["MediatorMobile"].ToString(); x.Notes = rd["Notes"].ToString(); x.Status = rd["Status"].ToString(); if (bringDetails) { x.Account = Account.GetAccountByOwnerID(Account.AccountType.Sponsor, x.SponsorID.Value); x.Sponsorships = Sponsorship.GetSponsorshipAllBySponsorID(x); x.AvailableSponsorships = AvailableSponsorship.GetAllAvailableSponsorshipBySponsorID(x); } } rd.Close(); } catch { x = null; } finally { con.Close(); } return(x); }
public NewSponsorshipsWindow(AvailableSponsorship a) { InitializeComponent(); this.DataContext = a; if (!a.ID.HasValue) { a.SponsorType = "كفالة خاصة"; } }
public static List <Sponsorship> GetAllSponsorship() { List <Sponsorship> xx = new List <Sponsorship>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_All_Sponsorship", con); com.CommandType = System.Data.CommandType.StoredProcedure; try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { Sponsorship x = new Sponsorship(); if (!(rd["ID"] is DBNull)) { x.ID = int.Parse(rd["ID"].ToString()); } if (!(rd["OrphanID"] is DBNull)) { x.OrphanID = int.Parse(rd["OrphanID"].ToString()); } if (!(rd["StartDate"] is DBNull)) { x.StartDate = DateTime.Parse(rd["StartDate"].ToString()); } if (!(rd["EndDate"] is DBNull)) { x.EndDate = DateTime.Parse(rd["EndDate"].ToString()); } x.Notes = rd["Notes"].ToString(); if (!(rd["LastUserID"] is DBNull)) { x.LastUserID = int.Parse(rd["LastUserID"].ToString()); } if (!(rd["AvailableSponsorshipID"] is DBNull)) { x.AvailableSponsorship = AvailableSponsorship.GetAvailableSponsorshipByID(int.Parse(rd["AvailableSponsorshipID"].ToString())); } x.IsDouble = (bool)rd["IsDouble"]; xx.Add(x); } rd.Close(); } catch { xx = null; } finally { con.Close(); } return(xx); }
public static Sponsorship GetCurrentSponsorshipByOrphanID(int OrphanId) { Sponsorship x = new Sponsorship(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_Current_Sponsorship", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@OrphanId", OrphanId); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.Read()) { if (!(rd["ID"] is DBNull)) { x.ID = int.Parse(rd["ID"].ToString()); } if (!(rd["OrphanID"] is DBNull)) { x.OrphanID = int.Parse(rd["OrphanID"].ToString()); } if (!(rd["StartDate"] is DBNull)) { x.StartDate = DateTime.Parse(rd["StartDate"].ToString()); } if (!(rd["EndDate"] is DBNull)) { x.EndDate = DateTime.Parse(rd["EndDate"].ToString()); } x.Notes = rd["Notes"].ToString(); if (!(rd["LastUserID"] is DBNull)) { x.LastUserID = int.Parse(rd["LastUserID"].ToString()); } if (!(rd["AvailableSponsorshipID"] is DBNull)) { x.AvailableSponsorship = AvailableSponsorship.GetAvailableSponsorshipByID(int.Parse(rd["AvailableSponsorshipID"].ToString())); } x.IsDouble = (bool)rd["IsDouble"]; } rd.Close(); } catch { x = null; } finally { con.Close(); } return(x); }
public static bool UpdateData(AvailableSponsorship x) { return(BaseDataBase._StoredProcedure("sp_Update_AvailableSponsorship" , new SqlParameter("@ID", x.ID) , new SqlParameter("@SponsorID", x.RelatedSponsor.SponsorID) , new SqlParameter("@NOB", x.NOB) , new SqlParameter("@Duration", x.Duration) , new SqlParameter("@SponsorshipValue", x.SponsorshipValue) , new SqlParameter("@SponsorshipType", x.SponsorshipType) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID) , new SqlParameter("@IsCompensated", x.IsCompensated) , new SqlParameter("@OverMonths", x.OverMonths) , new SqlParameter("@SponsorType", x.SponsorType) , new SqlParameter("@CreateDate", x.CreateDate))); }
private void btnAdd_Click(object sender, RoutedEventArgs e) { var a = this.DataContext as AvailableSponsorship; if (a != null) { if (a.IsValidate()) { if (AvailableSponsorship.InsertData(a)) { MyMessage.InsertMessage(); DialogResult = true; } } } }
public static bool InsertData(AvailableSponsorship x) { if (x.SponsorshipType == "") { x.Duration = null; } x.ID = BaseDataBase._StoredProcedureReturnable("sp_Add_AvailableSponsorship" , new SqlParameter("@ID", System.Data.SqlDbType.Int) , new SqlParameter("@SponsorID", x.RelatedSponsor.SponsorID) , new SqlParameter("@NOB", x.NOB) , new SqlParameter("@Duration", x.Duration) , new SqlParameter("@SponsorshipValue", x.SponsorshipValue) , new SqlParameter("@SponsorshipType", x.SponsorshipType) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID) , new SqlParameter("@IsCompensated", x.IsCompensated) , new SqlParameter("@OverMonths", x.OverMonths) , new SqlParameter("@SponsorType", x.SponsorType) , new SqlParameter("@CreateDate", x.CreateDate)); return(x.ID.HasValue); }
private void Filter() { ListCollectionView view = (ListCollectionView)CollectionViewSource.GetDefaultView(dgAvailableSponsorships.ItemsSource); view.Filter = delegate(object item) { AvailableSponsorship a = (AvailableSponsorship)item; if ((txtName.Text != "" && !a.RelatedSponsor.Name.Contains(txtName.Text))) { return(false); } if (cmboIsCompensated.SelectedIndex > 0 && (cmboIsCompensated.SelectedIndex == 1 && !a.IsCompensated) || (cmboIsCompensated.SelectedIndex == 2 && a.IsCompensated)) { return(false); } if (cmboIsGeneral.SelectedIndex > 0 && a.SponsorType != (cmboIsGeneral.SelectedIndex == 1 ? "كفالة خاصة" : "كفالة عامة")) { return(false); } return(true); }; }
public static List <AvailableSponsorship> GetAllAvailableSponsorshipBySponsorID(Sponsor s) { List <AvailableSponsorship> xx = new List <AvailableSponsorship>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_Get_SponsorID_AvailableSponsorship", con); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.Add(new SqlParameter("@SponsorID", s.SponsorID)); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { AvailableSponsorship x = new AvailableSponsorship(); x.RelatedSponsor = s; if (!(rd["ID"] is DBNull)) { x.ID = int.Parse(rd["ID"].ToString()); } if (!(rd["NOB"] is DBNull)) { x.NOB = int.Parse(rd["NOB"].ToString()); } x.remainingNOB = int.Parse(rd["RemainingNOB"].ToString()); if (!(rd["Duration"] is DBNull)) { x.Duration = double.Parse(rd["Duration"].ToString()); } if (!(rd["SponsorshipValue"] is DBNull)) { x.SponsorshipValue = double.Parse(rd["SponsorshipValue"].ToString()); } x.SponsorshipType = rd["SponsorshipType"].ToString(); x.Notes = rd["Notes"].ToString(); if (!(rd["LastUserID"] is DBNull)) { x.LastUserID = int.Parse(rd["LastUserID"].ToString()); } if (!(rd["IsCompensated"] is DBNull)) { x.IsCompensated = bool.Parse(rd["IsCompensated"].ToString()); } if (!(rd["OverMonths"] is DBNull)) { x.OverMonths = int.Parse(rd["OverMonths"].ToString()); } x.SponsorType = rd["SponsorType"].ToString(); if (!(rd["CreateDate"] is DBNull)) { x.CreateDate = DateTime.Parse(rd["CreateDate"].ToString()); } xx.Add(x); } rd.Close(); } catch { xx = null; } finally { con.Close(); } return(xx); }
public static bool DeleteData(AvailableSponsorship x) { return(BaseDataBase._StoredProcedure("sp_Delete_AvailableSponsorship" , new SqlParameter("@ID", x.ID))); }
public SelectAvailableSponsorshipControl() { InitializeComponent(); dgAvailableSponsorships.ItemsSource = AvailableSponsorship.GetAllAvailableSponsorship(); }