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)));
}
