public async Task <bool> AddProduct_Category(IProduct_Category product_Category)
{
var param = new
{
product_Category.UID,
product_Category.CAT_Date,
product_Category.CAT_Description,
product_Category.CAT_Name
};
return(await _dataBaseManager.Add("SP_ADD_Product_Category", param));
}
public async Task <bool> AddDesign(IDesign design)
{
var param = new
{
design.UID,
design.Date,
design.Description,
design.Design_Title,
};
return(await _dataBaseManager.Add("SP_ADD_Design", param));
}
public void PutCharacteristic(string name, string value, int IdNote)
{
Characteristic character;
try
{
character = _dataCharacter.GetBy("Name", name.ToString()).First();
}
catch (InvalidOperationException)
{
_dataCharacter.Add(new Characteristic()
{
Name = name
});
character = _dataCharacter.GetBy("Name", name.ToString()).First();
}
_dataNoteCharacter.Add(new Note_Characteristic()
{
Id_Characteristic = character.Id_Characteristic,
Id_Note = IdNote,
Value = value
});
}
public void Put(string noteOrFile, int id)
{
string login = User.Identity.Name.ToString();
if (noteOrFile == "note")
{
_dataNoteInfo.Add(new LikeNote()
{
Id_Note = id,
Login = login
});
}
else if (noteOrFile == "file")
{
_dataFileInfo.Add(new LikeFile()
{
Id_File = id,
Login = login
});
}
else
{
throw new ArgumentException("wrong description if likes");
}
}
public async Task <bool> AddProduct_Command(IProduct_Command product_Command)
{
var param = new
{
product_Command.UID,
product_Command.Date,
product_Command.UID_Supplier
};
return(await _dataBaseManager.Add("SP_ADD_Product_Command", param));
}
public async Task <bool> AddProduct_Brand(IProduct_Brand product_Brand)
{
var param = new
{
product_Brand.UID,
product_Brand.BRA_Name,
product_Brand.BRA_Description,
product_Brand.BRA_Date
};
return(await _dataBaseManager.Add("SP_ADD_Product_Brand", param));
}
public async Task <bool> AddOrder_Details(IOrder_Details order_Details)
{
var param = new
{
order_Details.UID,
order_Details.Date,
order_Details.UID_Customer,
order_Details.UID_Design
};
return(await _dataBaseManager.Add("SP_ADD_Order_Details", param));
}
public async Task <bool> AddService_Call(IService_Call service_Call)
{
var param = new
{
service_Call.UID,
service_Call.Caller_Info,
service_Call.Call_Description,
service_Call.Date_time,
service_Call.UID_Customer
};
return(await _dataBaseManager.Add("SP_ADD_Service_Call", param));
}
public async Task <bool> AddFile(IFile file)
{
var param = new
{
file.UID,
file.Date,
file.FIL_UID_Origin,
file.FIL_Name,
file.FIL_Path
};
return(await _dataBaseManager.Add("SP_ADD_File", param));
}
public async Task <bool> AddProduct_Stock(IProduct_Stock product_Stock)
{
var param = new
{
product_Stock.UID,
product_Stock.Init_Qte,
product_Stock.Status,
product_Stock.Date,
product_Stock.Product_UID
};
return(await _dataBaseManager.Add("SP_ADD_Product_Stock", param));
}
public async Task <bool> AddColor(IColor color)
{
var param = new
{
color.UID,
color.Color_Name,
color.Hex,
color.RGB,
color.UID_Product
};
return(await _dataBaseManager.Add("SP_ADD_Color", param));
}
public async Task <bool> AddEmployee_Work_Detail(IEmployee_Work_Details employee_Work_Detail)
{
var param = new
{
employee_Work_Detail.UID,
employee_Work_Detail.Date,
employee_Work_Detail.Worked_hours,
employee_Work_Detail.UID_Employee,
employee_Work_Detail.UID_Project
};
return(await _dataBaseManager.Add("SP_ADD_Employee_Work_Details", param));
}
public async Task <bool> AddProduct_Command_Details(IProduct_Command_Details product_Command_Details)
{
var param = new
{
product_Command_Details.UID,
product_Command_Details.PRO_Qte,
product_Command_Details.Total_Price,
product_Command_Details.UID_PRO,
product_Command_Details.UID_PRO_Command,
};
return(await _dataBaseManager.Add("SP_ADD_Product_Command_Details", param));
}
public async Task <bool> AddUsed_Products_Details(IUsed_Products_Details used_Products_Details)
{
var param = new
{
used_Products_Details.UID,
used_Products_Details.Date,
used_Products_Details.Damaged_numb,
used_Products_Details.Qte,
used_Products_Details.UID_PRO,
used_Products_Details.UID_Project
};
return(await _dataBaseManager.Add("SP_ADD_Used_Products_Details", param));
}
public async Task <bool> AddSupplier(ISupplier supplier)
{
var param = new
{
supplier.UID,
supplier.SUP_Contact_Name,
supplier.SUP_Email,
supplier.SUP_Name,
supplier.SUP_Phone,
supplier.SUP_Type,
supplier.SUP_URL,
supplier.UID_Address
};
return(await _dataBaseManager.Add("SP_ADD_Supplier", param));
}
public async Task <bool> AddAddress(IAddress InsertedAddress)
{
var param = new
{
InsertedAddress.UID,
InsertedAddress.ADR_City,
InsertedAddress.ADR_Country,
InsertedAddress.ADR_Number,
InsertedAddress.ADR_Postal_Code,
InsertedAddress.ADR_State,
InsertedAddress.ADR_Street,
InsertedAddress.ADR_Suite
};
return(await _dataBaseManager.Add("SP_ADD_Address", param));
}
public Task <bool> AddCompany(ICompany company)
{
var param = new
{
company.UID,
company.COM_GCR,
company.COM_Name,
company.COM_NEQ,
company.COM_RBQ,
company.COM_TPS,
company.COM_TVQ,
company.UID_Address
};
return(_dataBaseManager.Add("SP_ADD_Company", param));
}
public async Task <bool> AddProject(IProject project)
{
var param = new
{
project.UID,
project.Cost,
project.Finished_Date,
project.Start_Date,
project.Status,
project.Project_Title,
project.Progression,
project.UID_Property,
project.Canceled_or_stoped_cause
};
return(await _dataBaseManager.Add("SP_ADD_Project", param));
}
public async Task <bool> AddProduct_Composition(IProduct_Composition product_Composition)
{
var param = new
{
product_Composition.UID,
product_Composition.PDTC_Description,
product_Composition.PDTC_Extended_Cost,
product_Composition.PDTC_Libelle,
product_Composition.PDTC_Price,
product_Composition.PDTC_Quantity,
product_Composition.PDTC_Unite,
product_Composition.PDTC_Unit_Cost,
product_Composition.PDTC_UID_Compose,
product_Composition.PDTC_UID_Composant
};
return(await _dataBaseManager.Add("SP_ADD_Product_Composition", param));
}
public async Task <bool> AddProperty(IProperty property)
{
var param = new
{
property.UID,
property.Construction_Date,
property.Description,
property.Parts_To_Build,
property.PRO_Lot_Number,
property.PRO_Name,
property.PRO_UID_Customer,
property.PRO_UID_Type,
property.Size,
property.Size_Unit,
property.UID_Address
};
return(await _dataBaseManager.Add("SP_ADD_Property", param));
}
public async Task <bool> AddProduct(IProduct product)
{
var param = new
{
product.UID,
product.PDTC_Unite,
product.PRO_Description,
product.PRO_Enable_Retail_Sales,
product.PRO_Model_Number,
product.PRO_Name,
product.PRO_Price,
product.PRO_Retail_Price,
product.PRO_Retail_Tax,
product.PRO_Special_Price,
product.PRO_Supply_Price,
product.PRO_Type,
product.PRO_UID_Brand,
product.PRO_UID_Category,
product.PRO_Video_URL
};
return(await _dataBaseManager.Add("SP_ADD_Product", param));
}
protected void OnAddbuttonClicked(object sender, System.EventArgs e)
{
IDatabase db;
string dbname = MessagesHelpers.QueryMessage(this, Catalog.GetString("Database name"));
if (dbname == null || dbname == "")
{
return;
}
if (manager.Databases.Where(d => d.Name == dbname).Count() != 0)
{
var msg = Catalog.GetString("A database already exists with this name");
MessagesHelpers.ErrorMessage(this, msg);
return;
}
db = manager.Add(dbname);
if (db != null)
{
store.AppendValues(db);
}
}
public async Task <bool> AddCustomer(ICustomer customer)
{
var param = new
{
customer.UID,
CUS_First_Name = customer.USR_First_Name,
CUS_Last_Name = customer.USR_Last_Name,
CUS_Hashed_Password = customer.USR_Hashed_Password,
CUS_Salt = customer.USR_Salt,
CUS_Email = customer.USR_Email,
CUS_Created_DateTime = customer.USR_Create_Date,
CUS_Birth_Day = customer.USR_BirthDay,
CUS_Mobile = customer.USR_Phone_Mobile,
CUS_Username = customer.USR_Username,
customer.UID_Address,
customer.CUS_Spouse_First_Name,
customer.CUS_Spouse_Last_Name,
customer.CUS_Phone,
customer.CUS_Notes,
customer.CUS_Notes_2,
};
return(await _dataBaseManager.Add("SP_ADD_Customer", param));
}
public async Task <bool> AddEmployee(IEmployee employee)
{
var param = new
{
employee.UID,
employee.UID_Address,
employee.EMP_Employee_Number,
employee.EMP_Employee_Service,
employee.EMP_Extension_Number,
employee.EMP_Last_Login_Date,
employee.EMP_Phone,
EMP_BirthDay = employee.USR_BirthDay,
EMP_Create_Date = employee.USR_Create_Date,
EMP_Email = employee.USR_Email,
EMP_First_Name = employee.USR_First_Name,
EMP_Hashed_Password = employee.USR_Hashed_Password,
EMP_Last_Name = employee.USR_Last_Name,
EMP_Phone_Mobile = employee.USR_Phone_Mobile,
EMP_Salt = employee.USR_Salt,
EMP_Username = employee.USR_Username
};
return(await _dataBaseManager.Add("SP_ADD_Employee", param));
}