//To add a new customer
public ResultModel AddCustomer(CustomerModel input)
{
//Make db object
CustomerModelDB objCustomerModelDB = new CustomerModelDB
{
Active = input.Active,
Address = input.Address,
Code = input.Code,
ContactNumber = input.ContactNumber,
CreatedBy = input.CreatedBy,
CreatedDate = input.CreatedDate,
Description = input.Description,
Name = input.Name,
OtherInfo = input.OtherInfo,
SubDomain = input.SubDomain
};
//Save in database
RepositoryWrapper.CustomerRepository.Create(objCustomerModelDB);
RepositoryWrapper.CustomerRepository.Save();
return(new ResultModel {
PrimaryKey = input.CustomerId
});
}
public static int CreateCustomer(string name, string number, string address, string email, string NID, double rating, int bidLimit, string varificationStatus)
{
CustomerModelDB data = new CustomerModelDB
{
cName = name,
cNumber = number,
cAddress = address,
cEmail = email,
cNID = NID,
cRating = rating,
BidLimit = bidLimit,
VarificationStatus = varificationStatus
};
string sql = @"INSERT INTO dbo.Customer (cName, cNumber, cAddress, cEmail, cNID, cRating, BidLimit, VarificationStatus)
VALUES(@cName, @cNumber, @cAddress, @cEmail, @cNID, @cRating,@BidLimit, @VarificationStatus)";
return(SqlDataAccess.SaveData(sql, data));
}
