public static bool UpdateData(SpecialCardCenter x) { return(BaseDataBase._StoredProcedure("sp_Update_SpecialCardCenter" , new SqlParameter("@Id", x.Id) , new SqlParameter("@Name", x.Name) , new SqlParameter("@IsActive", x.IsActive) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID))); }
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))); }
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 UpdateData(FamilyNeed_ListerGroup x) { return(BaseDataBase._StoredProcedure("sp_UpdateFamilyNeed_ListerGroup" , new SqlParameter("@ID", x.ID) , new SqlParameter("@FamilyNeedListerID", x.FamilyNeedByLister.ID) , new SqlParameter("@ListerGroupID", x.ListerGroupID) , new SqlParameter("@OrderID", x.OrderID) , new SqlParameter("@Count", x.Count))); }
public static bool DeleteData(FormedBasket x) { if (x.id.HasValue) { FormedBasket_Sector.DeleteFormedBasketSectors(x); } return(BaseDataBase._StoredProcedure("sp_Delete_FormedBasket" , new SqlParameter("@Id", x.Id))); }
public static bool DeleteData(SpecialFamily x) { x.GetOrders(); foreach (var item in x.Orders) { Order.DeleteData(item); } return(BaseDataBase._StoredProcedure("sp_Delete_SpecialFamily", new SqlParameter("@Id", x.Id))); }
public bool DeleteSupervisorData() { if (BaseDataBase._StoredProcedure("sp_DeleteFromSupervisor" , new SqlParameter("@SupervisorID", SupervisorID))) { BaseDataBase.DeleteImageFIle(IdentityImage); return(true); } return(false); }
public static bool DeleteData(Training x) { foreach (var t in x.Trainees) { Trained.DeleteData(t); } return(BaseDataBase._StoredProcedure("sp_Delete_Training" , new SqlParameter("@ID", x.ID))); }
public bool DeletePersonQualificationData() { if (BaseDataBase._StoredProcedure("sp_DeleteFromPersonQualification" , new SqlParameter("@PersonQualificationID", PersonQualificationID))) { BaseDataBase.DeleteImageFIle(QualificationImage); return(true); } return(false); }
public bool UpdateData() { return(BaseDataBase._StoredProcedure("sp_UpdateOrphan_Specialty" , new SqlParameter("@ID", ID) , new SqlParameter("@OrphanID", OrphanID) , new SqlParameter("@SpecialtyID", SpecialtyID) , new SqlParameter("@SpecialtyValue", SpecialtyValue) , new SqlParameter("@Date", Date) , new SqlParameter("@Notes", Notes))); }
public bool DeleteData() { if (BaseDataBase._StoredProcedure("sp_DeleteFromimpeding" , new SqlParameter("@ID", ID))) { BaseDataBase.DeleteImageFIle(impedingIdentityImage); return(true); } return(false); }
public bool UpdateExternalFamilyFata() { return(BaseDataBase._StoredProcedure("sp_UpdateExternalFamilySupport" , new SqlParameter("@ExternalFamilySupportID", ExternalFamilySupportID) , new SqlParameter("@FamilyID", FamilyID) , new SqlParameter("@SupportType", SupportType) , new SqlParameter("@SupportSourse", SupportSourse) , new SqlParameter("@Value", Value) , new SqlParameter("@Date", Date) , new SqlParameter("@Notes", Notes))); }
public bool UpdateData() { return(BaseDataBase._StoredProcedure("sp_UpdateOrphan_Supervisor" , new SqlParameter("@ID", ID) , new SqlParameter("@SupervisorID", SupervisorID) , new SqlParameter("@OrphanID", OrphanID) , new SqlParameter("@Date", Date) , new SqlParameter("@EndDate", EndDate) , new SqlParameter("@SupervisorType", SupervisorType) , new SqlParameter("@Notes", Notes))); }
public bool UpdatePersonQualificationData() { QualificationImage = BaseDataBase.CheckImageFile(QualificationImage, Qualification.GetQualificationByID(PersonQualificationID).QualificationImage); return(BaseDataBase._StoredProcedure("sp_UpdatePersonQualification" , new SqlParameter("@PersonQualificationID", PersonQualificationID) , new SqlParameter("@PersonID", PersonID) , new SqlParameter("@QualificationName", QualificationName) , new SqlParameter("@DateOfQualification", DateOfQualification) , new SqlParameter("@QualificationImage", QualificationImage) , new SqlParameter("@Notes", Notes))); }
public bool InsertStudySideData() { return(BaseDataBase._StoredProcedure("sp_Add2StudySide" , new SqlParameter("@Name", Name) , new SqlParameter("@ResponsiblePerson", ResponsiblePerson) , new SqlParameter("@Phone", Phone) , new SqlParameter("@Mobile", Mobile) , new SqlParameter("@Email", Email) , new SqlParameter("@Notes", Notes) , new SqlParameter("@Address", Address))); }
public static bool UpdateData(Sponsorship x) { return(BaseDataBase._StoredProcedure("sp_Update_Sponsorship" , new SqlParameter("@ID", x.ID) , new SqlParameter("@OrphanID", x.OrphanID) , new SqlParameter("@StartDate", x.StartDate) , new SqlParameter("@EndDate", x.EndDate) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID) , new SqlParameter("@IsDouble", x.IsDouble) , new SqlParameter("@AvailableSponsorshipID", x.AvailableSponsorship.ID))); }
public static bool DeleteData(Invoice x) { if (x.Transitions != null) { foreach (var t in x.Transitions) { Transition.DeleteData(t); } } return(BaseDataBase._StoredProcedure("sp_Delete_Invoice" , new SqlParameter("@ID", x.ID), new SqlParameter("@ModifiedUserID", BaseDataBase.CurrentUser.ID))); }
public static bool UpdateData(Invoice x) { return(BaseDataBase._StoredProcedure("sp_Update_Invoice" , new SqlParameter("@ID", x.ID) , new SqlParameter("@CreateDate", x.CreateDate) , new SqlParameter("@Receiver", x.Receiver) , new SqlParameter("@ReceiverPID", x.ReceiverPID) , new SqlParameter("@TotalValue", x.TotalValue) , new SqlParameter("@Barcode", x.Barcode) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID) , new SqlParameter("@Description", x.Description))); }
public static bool UpdateData(ItemCriteria x) { return(BaseDataBase._StoredProcedure("sp_Update_ItemCriteria" , new SqlParameter("@ID", x.ID) , new SqlParameter("@ItemID", x.CriteriaItem.Id.Value) , new SqlParameter("@StartCriteria", x.StartCriteria) , new SqlParameter("@EndCriteria", x.EndCriteria) , new SqlParameter("@CriteriaType", x.CriteriaType) , new SqlParameter("@Count", x.Count) , new SqlParameter("@Evaluation", x.Evaluation) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID))); }
private void Button_Click_1(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(txtName.Text.Trim())) { MyMessageBox.Show("يجب إدخال اسم الجهة المستخدمة أولاً"); } else { BaseDataBase._StoredProcedure("sp_Add2MergedStudySide", new SqlParameter("@Name", txtName.Text.Trim())); this.DialogResult = true; } }
public bool UpdateOrphanHealthData() { return(BaseDataBase._StoredProcedure("sp_UpdateOrphanHealth" , new SqlParameter("@ID", ID) , new SqlParameter("@OrphanID", OrphanID) , new SqlParameter("@HealthSituation", HealthSituation) , new SqlParameter("@Date", Date) , new SqlParameter("@DayNeeded", DayNeeded) , new SqlParameter("@SpecialNeeded", SpecialNeeded) , new SqlParameter("@IsExist", IsExist) , new SqlParameter("@Notes", Notes))); }
public bool UpdateNominationData() { return(BaseDataBase._StoredProcedure("sp_UpdateNominationSide" , new SqlParameter("@NominationSideID", NominationSideID) , new SqlParameter("@Name", Name) , new SqlParameter("@AddDate", AddDate) , new SqlParameter("@Phone", Phone) , new SqlParameter("@Mobile", Mobile) , new SqlParameter("@Email", Email) , new SqlParameter("@Address", Address) , new SqlParameter("@ResponsiblePerson", ResponsiblePerson) , new SqlParameter("@Notes", Notes))); }
public static bool UpdateData(SpecialFamily x) { return(BaseDataBase._StoredProcedure("sp_Update_SpecialFamily", new SqlParameter("@Id", x.Id), new SqlParameter("@Name", x.Name), new SqlParameter("@PID", x.PID), new SqlParameter("@FatherName", x.FatherName), new SqlParameter("@MotherName", x.MotherName), new SqlParameter("@Gender", x.Gender), new SqlParameter("@DOB", x.DOB), new SqlParameter("@Notes", x.Notes), new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID))); }
public static bool UpdateData(Training x) { return(BaseDataBase._StoredProcedure("sp_Update_Training" , new SqlParameter("@ID", x.ID) , new SqlParameter("@Name", x.Name) , new SqlParameter("@StartDate", x.StartDate) , new SqlParameter("@EndDate", x.EndDate) , new SqlParameter("@TrainingGoal", x.TrainingGoal) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@IsCancelled", x.IsCancelled) , new SqlParameter("@CancelReason", x.CancelReason) , new SqlParameter("@Trainer", x.Trainer) , new SqlParameter("@Type", (int)x.Type))); }
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 DeleteData(Order x) { //foreach (var item in x.FamilyNeeds) //{ // item.OrderID = null; // FamilyNeed_ListerGroup.UpdateData(item); //} foreach (var item in x.OIs) { Order_Item.DeleteData(item); } return(BaseDataBase._StoredProcedure("sp_Delete_Order" , new SqlParameter("@Id", x.Id))); }
public static bool UpdateData(Transition x) { return(BaseDataBase._StoredProcedure("sp_Update_Transition" , new SqlParameter("@Id", x.Id) , new SqlParameter("@RightAccount", x.RightAccount.Id) , new SqlParameter("@LeftAccount", x.LeftAccount.Id) , new SqlParameter("@Value", x.Value) , new SqlParameter("@CreateDate", x.CreateDate) , new SqlParameter("@Details", x.Details) , new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID) , new SqlParameter("@IsHidden", x.IsHidden) , new SqlParameter("@InvoiceID", x.InvoiceID) , new SqlParameter("@SponsorshipID", x.SponsorshipID))); }
public static bool UpdateData(Trained x) { return(BaseDataBase._StoredProcedure("sp_Update_Trained" , new SqlParameter("@ID", x.ID) , new SqlParameter("@TrainingID", x.Training.ID) , new SqlParameter("@TrainedType", (int)x.TrainedType) , new SqlParameter("@TrainedID", x.TrainedID) , new SqlParameter("@IsAttended", x.IsAttended) , new SqlParameter("@IsAbiding", x.IsAbiding) , new SqlParameter("@Evaluation", x.Evaluation) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@AttendedExam", x.AttendedExam) , new SqlParameter("@TakeCertificate", x.TakeCertificate))); }
public bool UpdateData() { return(BaseDataBase._StoredProcedure("sp_UpdateTeachingStage" , new SqlParameter("@ID", ID) , new SqlParameter("@OrphanID", OrphanID) , new SqlParameter("@StudyStage", StudyStage) , new SqlParameter("@School", School) , new SqlParameter("@Class", Class) , new SqlParameter("@Evaluation", Evaluation) , new SqlParameter("@EvaluationReason", EvaluationReason) , new SqlParameter("@Date", Date) , new SqlParameter("@IsStopped", IsStopped) , new SqlParameter("@StopReason", StopReason) , new SqlParameter("@Notes", Notes))); }
public static bool UpdateData(Account x) { return(BaseDataBase._StoredProcedure("sp_Update_Account" , new SqlParameter("@Id", x.Id) , new SqlParameter("@Name", x.Name) , new SqlParameter("@Type", (int)x.Type) , new SqlParameter("@CurrentBalance", x.CurrentBalance) , new SqlParameter("@CreateDate", x.CreateDate) , new SqlParameter("@OwnerID", x.OwnerID) , new SqlParameter("@Status", x.Status) , new SqlParameter("@LastUserID", x.LastUserID) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@IsDebit", x.IsDebit) , new SqlParameter("@Code", x.Code))); }