public async Task <bool> ModifyProduct_Command(IProduct_Command modifiedProduct_Command)
{
var param = new
{
modifiedProduct_Command.UID,
modifiedProduct_Command.Date,
modifiedProduct_Command.UID_Supplier
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Command", param));
}
public async Task <bool> ModifyProduct_Brand(IProduct_Brand modifiedProduct_Brand)
{
var param = new
{
modifiedProduct_Brand.UID,
modifiedProduct_Brand.BRA_Name,
modifiedProduct_Brand.BRA_Description,
modifiedProduct_Brand.BRA_Date
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Brand", param));
}
public async Task <bool> ModifyProduct_Category(IProduct_Category modifiedProduct_Category)
{
var param = new
{
modifiedProduct_Category.UID,
modifiedProduct_Category.CAT_Date,
modifiedProduct_Category.CAT_Description,
modifiedProduct_Category.CAT_Name
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Category", param));
}
public async Task <bool> ModifyDesign(IDesign modifiedDesign)
{
var param = new
{
modifiedDesign.UID,
modifiedDesign.Date,
modifiedDesign.Description,
modifiedDesign.Design_Title,
};
return(await _dataBaseManager.Modify("SP_UPDATE_Design", param));
}
public async Task <bool> ModifyOrder_Details(IOrder_Details modifiedOrder_Details)
{
var param = new
{
modifiedOrder_Details.UID,
modifiedOrder_Details.Date,
modifiedOrder_Details.UID_Customer,
modifiedOrder_Details.UID_Design
};
return(await _dataBaseManager.Modify("SP_UPDATE_Order_Details", param));
}
public async Task <bool> ModifyService_Call(IService_Call modifiedService_Call)
{
var param = new
{
modifiedService_Call.UID,
modifiedService_Call.Caller_Info,
modifiedService_Call.Call_Description,
modifiedService_Call.Date_time,
modifiedService_Call.UID_Customer
};
return(await _dataBaseManager.Modify("SP_UPDATE_Service_Call", param));
}
public async Task <bool> ModifyProduct_Command_Details(IProduct_Command_Details modifiedProduct_Command_Details)
{
var param = new
{
modifiedProduct_Command_Details.UID,
modifiedProduct_Command_Details.PRO_Qte,
modifiedProduct_Command_Details.Total_Price,
modifiedProduct_Command_Details.UID_PRO,
modifiedProduct_Command_Details.UID_PRO_Command,
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Command_Details", param));
}
public async Task <bool> ModifyEmployee_Work_Detail(IEmployee_Work_Details modifiedEmployee_Work_Detail)
{
var param = new
{
modifiedEmployee_Work_Detail.UID,
modifiedEmployee_Work_Detail.Date,
modifiedEmployee_Work_Detail.Worked_hours,
modifiedEmployee_Work_Detail.UID_Employee,
modifiedEmployee_Work_Detail.UID_Project
};
return(await _dataBaseManager.Modify("SP_UPDATE_Employee_Work_Details", param));
}
public async Task <bool> ModifyColor(IColor NewColor)
{
var param = new
{
NewColor.UID,
NewColor.UID_Product,
NewColor.Color_Name,
NewColor.Hex,
NewColor.RGB
};
return(await _dataBaseManager.Modify("SP_UPDATE_Color", param));
}
public async Task <bool> ModifyFile(IFile modifiedFile)
{
var param = new
{
modifiedFile.UID,
modifiedFile.Date,
modifiedFile.FIL_UID_Origin,
modifiedFile.FIL_Name,
modifiedFile.FIL_Path
};
return(await _dataBaseManager.Modify("SP_UPDATE_File", param));
}
public async Task <bool> ModifyProduct_Stock(IProduct_Stock modifiedProduct_Stock)
{
var param = new
{
modifiedProduct_Stock.UID,
modifiedProduct_Stock.Init_Qte,
modifiedProduct_Stock.Current_Qte,
modifiedProduct_Stock.Status,
modifiedProduct_Stock.Date,
modifiedProduct_Stock.Product_UID
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Stock", param));
}
public async Task <bool> ModifyUsed_Products_Details(IUsed_Products_Details modifiedUsed_Products_Details)
{
var param = new
{
modifiedUsed_Products_Details.UID,
modifiedUsed_Products_Details.Date,
modifiedUsed_Products_Details.Damaged_numb,
modifiedUsed_Products_Details.Qte,
modifiedUsed_Products_Details.UID_PRO,
modifiedUsed_Products_Details.UID_Project
};
return(await _dataBaseManager.Modify("SP_UPDATE_Used_Products_Details", param));
}
public Task <bool> ModifyCompany(ICompany ModifiedCompany)
{
var param = new
{
ModifiedCompany.UID,
ModifiedCompany.COM_GCR,
ModifiedCompany.COM_Name,
ModifiedCompany.COM_NEQ,
ModifiedCompany.COM_RBQ,
ModifiedCompany.COM_TPS,
ModifiedCompany.COM_TVQ,
ModifiedCompany.UID_Address
};
return(_dataBaseManager.Modify("SP_UPDATE_Company", param));
}
public async Task <bool> ModifyAddress(IAddress Newaddress)
{
var param = new
{
Newaddress.UID,
Newaddress.ADR_City,
Newaddress.ADR_Country,
Newaddress.ADR_Number,
Newaddress.ADR_Postal_Code,
Newaddress.ADR_State,
Newaddress.ADR_Street,
Newaddress.ADR_Suite
};
return(await _dataBaseManager.Modify("SP_UPDATE_Address", param));
}
public async Task <bool> ModifySupplier(ISupplier modifiedSupplier)
{
var param = new
{
modifiedSupplier.UID,
modifiedSupplier.SUP_Contact_Name,
modifiedSupplier.SUP_Email,
modifiedSupplier.SUP_Name,
modifiedSupplier.SUP_Phone,
modifiedSupplier.SUP_Type,
modifiedSupplier.SUP_URL,
modifiedSupplier.UID_Address
};
return(await _dataBaseManager.Modify("SP_UPDATE_Supplier", param));
}
public async Task <bool> ModifyProject(IProject modifiedProject)
{
var param = new
{
modifiedProject.UID,
modifiedProject.Cost,
modifiedProject.Finished_Date,
modifiedProject.Start_Date,
modifiedProject.Status,
modifiedProject.Project_Title,
modifiedProject.Progression,
modifiedProject.UID_Property,
modifiedProject.Canceled_or_stoped_cause
};
return(await _dataBaseManager.Modify("SP_UPDATE_Project", param));
}
public async Task <bool> ModifyProduct_Composition(IProduct_Composition modifiedProduct_Composition)
{
var param = new
{
modifiedProduct_Composition.UID,
modifiedProduct_Composition.PDTC_Description,
modifiedProduct_Composition.PDTC_Extended_Cost,
modifiedProduct_Composition.PDTC_Libelle,
modifiedProduct_Composition.PDTC_Price,
modifiedProduct_Composition.PDTC_Quantity,
modifiedProduct_Composition.PDTC_Unite,
modifiedProduct_Composition.PDTC_Unit_Cost,
modifiedProduct_Composition.PDTC_UID_Compose,
modifiedProduct_Composition.PDTC_UID_Composant
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Composition", param));
}
public async Task <bool> ModifyProperty(IProperty modifiedProperty)
{
var param = new
{
modifiedProperty.UID,
modifiedProperty.Construction_Date,
modifiedProperty.Description,
modifiedProperty.Parts_To_Build,
modifiedProperty.PRO_Lot_Number,
modifiedProperty.PRO_Name,
modifiedProperty.PRO_UID_Customer,
modifiedProperty.PRO_UID_Type,
modifiedProperty.Size,
modifiedProperty.Size_Unit,
modifiedProperty.UID_Address
};
return(await _dataBaseManager.Modify("SP_UPDATE_Property", param));
}
public async Task <bool> ModifyProduct(IProduct modifiedProduct)
{
var param = new
{
modifiedProduct.UID,
modifiedProduct.PDTC_Unite,
modifiedProduct.PRO_Description,
modifiedProduct.PRO_Enable_Retail_Sales,
modifiedProduct.PRO_Model_Number,
modifiedProduct.PRO_Name,
modifiedProduct.PRO_Price,
modifiedProduct.PRO_Retail_Price,
modifiedProduct.PRO_Retail_Tax,
modifiedProduct.PRO_Special_Price,
modifiedProduct.PRO_Supply_Price,
modifiedProduct.PRO_Type,
modifiedProduct.PRO_UID_Brand,
modifiedProduct.PRO_UID_Category,
modifiedProduct.PRO_Video_URL
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product", param));
}
public async Task <bool> ModifyEmployee(IEmployee mofiedEmployee)
{
var param = new
{
mofiedEmployee.UID,
mofiedEmployee.UID_Address,
mofiedEmployee.EMP_Employee_Number,
mofiedEmployee.EMP_Employee_Service,
mofiedEmployee.EMP_Extension_Number,
mofiedEmployee.EMP_Last_Login_Date,
mofiedEmployee.EMP_Phone,
EMP_BirthDay = mofiedEmployee.USR_BirthDay,
EMP_Create_Date = mofiedEmployee.USR_Create_Date,
EMP_Email = mofiedEmployee.USR_Email,
EMP_First_Name = mofiedEmployee.USR_First_Name,
EMP_Hashed_Password = mofiedEmployee.USR_Hashed_Password,
EMP_Last_Name = mofiedEmployee.USR_Last_Name,
EMP_Phone_Mobile = mofiedEmployee.USR_Phone_Mobile,
EMP_Salt = mofiedEmployee.USR_Salt,
EMP_Username = mofiedEmployee.USR_Username
};
return(await _dataBaseManager.Modify("SP_UPDATE_Employee", param));
}
public async Task <bool> ModifyCustomer(ICustomer ModifiedCustomer)
{
var param = new
{
ModifiedCustomer.UID,
CUS_First_Name = ModifiedCustomer.USR_First_Name,
CUS_Last_Name = ModifiedCustomer.USR_Last_Name,
CUS_Hashed_Password = ModifiedCustomer.USR_Hashed_Password,
CUS_Salt = ModifiedCustomer.USR_Salt,
CUS_Email = ModifiedCustomer.USR_Email,
CUS_Created_DateTime = ModifiedCustomer.USR_Create_Date,
CUS_Mobile = ModifiedCustomer.USR_Phone_Mobile,
CUS_Birth_Day = ModifiedCustomer.USR_BirthDay,
CUS_Username = ModifiedCustomer.USR_Username,
ModifiedCustomer.UID_Address,
ModifiedCustomer.CUS_Spouse_First_Name,
ModifiedCustomer.CUS_Spouse_Last_Name,
ModifiedCustomer.CUS_Phone,
ModifiedCustomer.CUS_Notes,
ModifiedCustomer.CUS_Notes_2,
};
return(await _dataBaseManager.Modify("SP_UPDATE_Customer", param));
}
