private void dgCard_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
var c = e.Row.DataContext as SpecialCard;
if (c != null && c.IsValidate())
{
if (!c.ID.HasValue)
{
if (SpecialCard.InsertData(c))
{
MyMessage.InsertMessage();
}
else
{
e.Cancel = true;
}
}
else
{
if (SpecialCard.UpdateData(c))
{
MyMessage.UpdateMessage();
}
else
{
e.Cancel = true;
}
}
}
}
}
public SpecialCardControl()
{
InitializeComponent();
cmboType.ItemsSource = SpecialCardSource.Types;
cmboSpecialCard.ItemsSource = SpecialCard.GetAllSpecialCard().Where(x => x.IsActive).ToList();
cmboCenter.ItemsSource = SpecialCardCenter.GetAllSpecialCardCenter().Where(x => x.IsActive).ToList();
}
public static bool UpdateData(SpecialCard x)
{
return(BaseDataBase._StoredProcedure("sp_Update_SpecialCard"
, new SqlParameter("@ID", x.ID)
, new SqlParameter("@Name", x.Name)
, new SqlParameter("@IsActive", x.IsActive)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)));
}
public static bool InsertData(SpecialCard x)
{
x.ID = BaseDataBase._StoredProcedureReturnable("sp_Add_SpecialCard"
, new SqlParameter("@ID", System.Data.SqlDbType.Int)
, new SqlParameter("@Name", x.Name)
, new SqlParameter("@IsActive", x.IsActive)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID));
return(x.ID.HasValue);
}
public static SpecialCard GetSpecialCardByID(int id)
{
SpecialCard x = new SpecialCard();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_ID_SpecialCard", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@ID", id);
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());
}
x.Name = rd["Name"].ToString();
if (!(rd["IsActive"] is DBNull))
{
x.IsActive = bool.Parse(rd["IsActive"].ToString());
}
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
public static List <SpecialCard> GetAllSpecialCard()
{
List <SpecialCard> xx = new List <SpecialCard>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_All_SpecialCard", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
SpecialCard x = new SpecialCard();
if (!(rd["ID"] is DBNull))
{
x.ID = int.Parse(rd["ID"].ToString());
}
x.Name = rd["Name"].ToString();
if (!(rd["IsActive"] is DBNull))
{
x.IsActive = bool.Parse(rd["IsActive"].ToString());
}
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
xx.Add(x);
}
rd.Close();
}
catch
{
xx = null;
}
finally
{
con.Close();
}
return(xx);
}
private void btnDeleteCard_Click(object sender, RoutedEventArgs e)
{
var c = dgCard.SelectedItem as SpecialCard;
if (c != null)
{
if (c.CanRemove())
{
if (SpecialCard.DeleteData(c))
{
dgCard.ItemsSource = null;
dgCard.ItemsSource = SpecialCard.GetAllSpecialCard();
MyMessage.DeleteMessage();
}
}
else
{
MyMessageBox.Show("لايمكن حذف البطاقة الخاصة بسبب وجود بطاقات مرتبطة بالعوائل او الافراد");
}
}
}
public static bool DeleteData(SpecialCard x)
{
return(BaseDataBase._StoredProcedure("sp_Delete_SpecialCard"
, new SqlParameter("@ID", x.ID)));
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
dgCard.ItemsSource = SpecialCard.GetAllSpecialCard();
dgCenter.ItemsSource = SpecialCardCenter.GetAllSpecialCardCenter();
}