private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!(BaseDataBase.CurrentUser.CanUpdateFamily || BaseDataBase.CurrentUser.PointAdmin))
{
MessageBox.Show("ليس لديك صلاحية اضافة بطافة خاصة");
return;
}
var x = this.DataContext as SpecialCardSource;
if (x.IsValidate())
{
if (x.Id.HasValue)
{
if (!BaseDataBase.CurrentUser.PointAdmin)
{
MessageBox.Show("ليس لديك صلاحية تعديل بطافة خاصة");
return;
}
if (BaseDataBase.CurrentUser.CanUpdate && SpecialCardSource.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
else
{
if (SpecialCardSource.InsertData(x))
{
MyMessage.InsertMessage();
SpecialCardSources.Add(x);
TotalCount = SpecialCardSources.Count;
Place = TotalCount;
}
}
}
}
public static bool UpdateData(SpecialCardSource x)
{
return(BaseDataBase._StoredProcedure("sp_Update_SpecialCardSource"
, new SqlParameter("@Id", x.Id)
, new SqlParameter("@SpecialCardID", x.SpecialCardID)
, new SqlParameter("@CenterID", x.CenterID)
, new SqlParameter("@BeneficiaryType", x.BeneficiaryType)
, new SqlParameter("@BeneficiaryID", x.BeneficiaryID)
, new SqlParameter("@StartDate", x.StartDate)
, new SqlParameter("@EndDate", x.EndDate)
, new SqlParameter("@Notes", x.Notes)
, new SqlParameter("@Code", x.Code)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)));
}
public static bool InsertData(SpecialCardSource x)
{
x.Id = BaseDataBase._StoredProcedureReturnable("sp_Add_SpecialCardSource"
, new SqlParameter("@Id", System.Data.SqlDbType.Int)
, new SqlParameter("@SpecialCardID", x.SpecialCardID)
, new SqlParameter("@CenterID", x.CenterID)
, new SqlParameter("@BeneficiaryType", x.BeneficiaryType)
, new SqlParameter("@BeneficiaryID", x.BeneficiaryID)
, new SqlParameter("@StartDate", x.StartDate)
, new SqlParameter("@EndDate", x.EndDate)
, new SqlParameter("@Notes", x.Notes)
, new SqlParameter("@Code", x.Code)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID));
return(x.Id.HasValue);
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as SpecialCardSource;
if (x == null || x.Id.HasValue)
{
try
{
var MaxEndDate = SpecialCardSources.Select(s => s.EndDate).Max().Value;
if (BaseDataBase.DateNow < MaxEndDate)
{
MyMessageBox.Show("تاريخ نهاية البطاقة السابقة هو " + MaxEndDate.ToShortDateString());
return;
}
}
catch { }
var scs = new SpecialCardSource();
scs.StartDate = BaseDataBase.DateNow;
scs.EndDate = scs.StartDate.Value.AddDays(120);
this.DataContext = scs;
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as SpecialCardSource;
if (x.Id.HasValue)
{
if (!BaseDataBase.CurrentUser.PointAdmin)
{
MyMessageBox.Show("لا يوجد لديك صلاحيات للحذف");
}
else if (MyMessageBox.Show("هل تريد تأكيد حذف البيانات", MessageBoxButton.YesNo) == MessageBoxResult.Yes && SpecialCardSource.DeleteData(x))
{
MyMessage.DeleteMessage();
FamilyID = FamilyID;
}
}
}
public static List <SpecialCardSource> GetAllSpecialCardSourcByFamilyID(int FamilyID)
{
List <SpecialCardSource> xx = new List <SpecialCardSource>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_FamilyID_SpecialCardSource", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@FamilyID", FamilyID);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
SpecialCardSource x = new SpecialCardSource();
if (!(rd["Id"] is DBNull))
{
x.Id = int.Parse(rd["Id"].ToString());
}
if (!(rd["SpecialCardID"] is DBNull))
{
x.SpecialCardID = int.Parse(rd["SpecialCardID"].ToString());
}
if (!(rd["CenterID"] is DBNull))
{
x.CenterID = int.Parse(rd["CenterID"].ToString());
}
if (!(rd["BeneficiaryType"] is DBNull))
{
x.BeneficiaryType = int.Parse(rd["BeneficiaryType"].ToString());
}
if (!(rd["BeneficiaryID"] is DBNull))
{
x.BeneficiaryID = int.Parse(rd["BeneficiaryID"].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());
}
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
x.Notes = rd["Notes"].ToString();
x.Code = rd["Code"].ToString();
xx.Add(x);
}
rd.Close();
}
catch
{
xx = new List <MainWPF.SpecialCardSource>();
}
finally
{
con.Close();
}
return(xx);
}
public static bool DeleteData(SpecialCardSource x)
{
return(BaseDataBase._StoredProcedure("sp_Delete_SpecialCardSource"
, new SqlParameter("@Id", x.Id)));
}
