public void SaveProduct(ProductModel objProductModel) // save category
{
tblAddress objtblAddress = new tblAddress()
{
Id = objProductModel.Address.Id,
AddressLine1 = objProductModel.Address.AddressLine1,
AddressLine2 = objProductModel.Address.AddressLine2,
City = objProductModel.Address.City,
State = objProductModel.Address.State,
Country = objProductModel.Address.Country
};
tblProduct objProduct = new tblProduct() // database class instance
{
ID = objProductModel.Id,
Name = objProductModel.Name, // assign model property to daatabase class
Brand = objProductModel.Brand,
ModelNo = objProductModel.ModelNo,
Category = objProductModel.Category,
Condition = objProductModel.Condition,
BuyNowPrice = (int)objProductModel.BuyNowPrice,
BidPrice = (int)objProductModel.BidPrice,
Quantity = objProductModel.Quantity,
AddressID = objProductModel.AddressId,
BidEndDateTime = Convert.ToDateTime(objProductModel.BidDateTime),
ImagePath = objProductModel.ImagePath,
AddedByUserId = (int)objProductModel.AddedByUserId,
tblAddress = objtblAddress
};
objWITSProjectEntities.tblProduct.Add(objProduct); // add record into database
objWITSProjectEntities.SaveChanges(); // save the record into table
}
public void SaveOffer(ProductOfferModel objProductOfferModel) // save offer data and returns int value
{
tblOfferPrice tblOffer = new tblOfferPrice()
{
OfferId = objProductOfferModel.OfferId,
OfferPrice = objProductOfferModel.OfferPrice,
SenderId = objProductOfferModel.SenderId,
ReceiverId = objProductOfferModel.ReceiverId,
Product_Id = objProductOfferModel.ProductId,
Status = objProductOfferModel.Status,
Message = objProductOfferModel.Message,
Counter = objProductOfferModel.Counter,
};
objWITSProjectEntities.tblOfferPrice.Add(tblOffer);
objWITSProjectEntities.SaveChanges();
}
public int SignUp(UserModel userModel) // register new user in webstie
{
Product.Data.User objUser = new User() // product class object for fetch data
{
Id = userModel.Id, // assign model property to daatabase class
UserName = userModel.Name,
Password = userModel.Password,
//ConfirmPassword = userModel.ConfirmPassword,
Email = userModel.Email
};
objWITSProjectEntities.User.Add(objUser); //add new record into database
return(objWITSProjectEntities.SaveChanges()); // save record in database
}
public int SaveAddress(AddressModel addressModel) // save new address
{
tblAddress address = new tblAddress()
{
Id = addressModel.Id,
AddressLine1 = addressModel.AddressLine1,
AddressLine2 = addressModel.AddressLine2,
City = addressModel.City,
State = addressModel.State,
Country = addressModel.Country
};
objWITSProjectEntities.tblAddress.Add(address);
objWITSProjectEntities.SaveChanges();
return(address.Id);
}