public static bool UpdateData(TempChild tc) { return(BaseDataBase._StoredProcedure("sp_UpdateTempChild" , new SqlParameter("@ChildID", tc.ChildID) , new SqlParameter("@TempFamilyID", tc.TempFamilyID) , new SqlParameter("@Name", tc.Name) , new SqlParameter("@DOB", tc.DOB) , new SqlParameter("@Gender", tc.Gender))); }
public static bool DeleteData(TempFamily t) { foreach (var c in t.TempChilds) { TempChild.DeleteData(c); } return(BaseDataBase._StoredProcedure("sp_DeleteFromTempFamily" , new SqlParameter("@ID", t.ID))); }
private void btnChild_Click(object sender, RoutedEventArgs e) { var tf = this.DataContext as TempFamily; var tc = grdChild.DataContext as TempChild; if (tc == null) { return; } if (radDel.IsChecked == true) { if (MyMessageBox.Show("هل تريد تأكيد الحذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (!tc.ChildID.HasValue || TempChild.DeleteData(tc)) { tf.TempChilds.Remove(tc); dgChild.Items.Refresh(); MyMessage.DeleteMessage(); radAdd.IsChecked = true; } } } else { if (tc.IsValidate()) { if (radAdd.IsChecked == true) { tc.TempFamilyID = tf.ID; if (!tf.ID.HasValue || TempChild.InsertData(tc)) { tf.TempChilds.Add(tc); dgChild.Items.Refresh(); grdChild.DataContext = new TempChild(); Keyboard.Focus(txtChildName); if (tf.ID.HasValue) { MyMessage.InsertMessage(); } } } else { tc.TempFamilyID = tf.ID; if (!tf.ID.HasValue || TempChild.UpdateData(tc)) { dgChild.Items.Refresh(); if (tf.ID.HasValue) { MyMessage.UpdateMessage(); } } } } } }
public static bool InsertData(TempChild tc) { tc.ChildID = BaseDataBase._StoredProcedureReturnable("sp_Add2TempChild" , new SqlParameter("@ChildID", System.Data.SqlDbType.Int) , new SqlParameter("@TempFamilyID", tc.TempFamilyID) , new SqlParameter("@Name", tc.Name) , new SqlParameter("@DOB", tc.DOB) , new SqlParameter("@Gender", tc.Gender)); return(tc.ChildID.HasValue); }
public static bool InsertData(TempFamily t) { t.Creator = BaseDataBase.CurrentUser.Name; t.ID = BaseDataBase._StoredProcedureReturnable("sp_Add2TempFamily" , new SqlParameter("@ID", System.Data.SqlDbType.Int) , new SqlParameter("@FamilyName", t.FamilyName) , new SqlParameter("@FamilyCode", t.FamilyCode) , new SqlParameter("@ApplyDate", t.ApplyDate) , new SqlParameter("@Notes", t.Notes) , new SqlParameter("@FamilyType", t.FamilyType) , new SqlParameter("@FamilyIdentityID", t.FamilyIdentityID) , new SqlParameter("@FatherFirstName", t.FatherFirstName) , new SqlParameter("@FatherFatherName", t.FatherFatherName) , new SqlParameter("@FatherLastName", t.FatherLastName) , new SqlParameter("@FatherBornPlace", t.FatherBornPlace) , new SqlParameter("@FatherPID", t.FatherPID) , new SqlParameter("@FatherDOB", t.FatherDOB) , new SqlParameter("@MotherFirstName", t.MotherFirstName) , new SqlParameter("@MotherFatherName", t.MotherFatherName) , new SqlParameter("@MotherLastName", t.MotherLastName) , new SqlParameter("@MotherBornPlace", t.MotherBornPlace) , new SqlParameter("@MotherPID", t.MotherPID) , new SqlParameter("@MotherDOB", t.MotherDOB) , new SqlParameter("@Phone", t.Phone) , new SqlParameter("@Mobile1", t.Mobile1) , new SqlParameter("@Mobile2", t.Mobile2) , new SqlParameter("@IsPrinted", t.IsPrinted) , new SqlParameter("@Printer", t.Printer) , new SqlParameter("@HouseSection", t.HouseSection) , new SqlParameter("@HouseStreet", t.HouseStreet) , new SqlParameter("@HouseBuildingNumber", t.HouseBuildingNumber) , new SqlParameter("@HouseFloor", t.HouseFloor) , new SqlParameter("@HouseAddress", t.HouseAddress) , new SqlParameter("@HouseOldAddress", t.HouseOldAddress) , new SqlParameter("@Creator", t.Creator) , new SqlParameter("@IsCancelled", t.IsCancelled) , new SqlParameter("@FamilyPersonCount", t.FamilyPersonCount) , new SqlParameter("@CancelReason", t.CancelReason) , new SqlParameter("@FamilyID", t.FamilyID) ); t.FamilyCode = BaseDataBase._Scalar("select FamilyCode from TempFamily where Id = " + t.ID); foreach (var tc in t.TempChilds) { tc.TempFamilyID = t.ID; TempChild.InsertData(tc); } return(t.ID.HasValue); }
public static List <TempChild> GetTempChildsByTempFamilyID(int id) { List <TempChild> tcs = new List <TempChild>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetTempChildsAllByTempFamilyID", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@TempFamilyID", id); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { TempChild tc = new TempChild(); if (!(rd["ChildID"] is DBNull)) { tc.ChildID = System.Int32.Parse(rd["ChildID"].ToString()); } tc.Name = rd["Name"].ToString(); tc.Gender = rd["Gender"].ToString(); if (!(rd["DOB"] is DBNull)) { tc.DOB = System.DateTime.Parse(rd["DOB"].ToString()); } tcs.Add(tc); } rd.Close(); } catch { tcs = new List <TempChild>(); } finally { con.Close(); } return(tcs); }
public static bool DeleteData(TempChild tc) { return(BaseDataBase._StoredProcedure("sp_DeleteFromTempChild" , new SqlParameter("@ChildID", tc.ChildID))); }
public static List <TempFamily> GetTempFamilyAll() { List <TempFamily> tfs = new List <TempFamily>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetTempFamilyAll", con); com.CommandType = System.Data.CommandType.StoredProcedure; try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { TempFamily x = new TempFamily(); if (!(rd["ID"] is DBNull)) { x.ID = System.Int32.Parse(rd["ID"].ToString()); } x.FamilyName = rd["FamilyName"].ToString(); x.FamilyCode = rd["FamilyCode"].ToString(); if (!(rd["ApplyDate"] is DBNull)) { x.ApplyDate = System.DateTime.Parse(rd["ApplyDate"].ToString()); } x.FamilyIdentityID = rd["FamilyIdentityID"].ToString(); if (!(rd["FamilyPersonCount"] is DBNull)) { x.FamilyPersonCount = System.Int32.Parse(rd["FamilyPersonCount"].ToString()); } x.Notes = rd["Notes"].ToString(); x.FamilyType = rd["FamilyType"].ToString(); x.FatherFirstName = rd["FatherFirstName"].ToString(); x.FatherFatherName = rd["FatherFatherName"].ToString(); x.FatherLastName = rd["FatherLastName"].ToString(); x.FatherBornPlace = rd["FatherBornPlace"].ToString(); x.FatherPID = rd["FatherPID"].ToString(); if (!(rd["FatherDOB"] is DBNull)) { x.FatherDOB = System.DateTime.Parse(rd["FatherDOB"].ToString()); } x.MotherFirstName = rd["MotherFirstName"].ToString(); x.MotherFatherName = rd["MotherFatherName"].ToString(); x.MotherLastName = rd["MotherLastName"].ToString(); x.MotherBornPlace = rd["MotherBornPlace"].ToString(); x.MotherPID = rd["MotherPID"].ToString(); if (!(rd["MotherDOB"] is DBNull)) { x.MotherDOB = System.DateTime.Parse(rd["MotherDOB"].ToString()); } x.Phone = rd["Phone"].ToString(); x.Mobile1 = rd["Mobile1"].ToString(); x.Mobile2 = rd["Mobile2"].ToString(); if (!(rd["IsPrinted"] is DBNull)) { x.IsPrinted = System.Boolean.Parse(rd["IsPrinted"].ToString()); } x.Printer = rd["Printer"].ToString(); x.HouseSection = rd["HouseSection"].ToString(); x.HouseStreet = rd["HouseStreet"].ToString(); x.HouseBuildingNumber = rd["HouseBuildingNumber"].ToString(); x.HouseFloor = rd["HouseFloor"].ToString(); x.HouseAddress = rd["HouseAddress"].ToString(); x.HouseOldAddress = rd["HouseOldAddress"].ToString(); if (!(rd["IsCancelled"] is DBNull)) { x.IsCancelled = System.Boolean.Parse(rd["IsCancelled"].ToString()); } x.CancelReason = rd["CancelReason"].ToString(); x.Creator = rd["Creator"].ToString(); if (!(rd["FamilyID"] is DBNull)) { x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString()); } x.TempChilds = TempChild.GetTempChildsByTempFamilyID(x.ID.Value); tfs.Add(x); } rd.Close(); } catch { tfs = new List <TempFamily>(); } finally { con.Close(); } return(tfs); }