public int Edit(int id, DressDetailsModel ObjDressDetailsModel)
{
try
{
if (id > 0)
{
if (ObjDressDetailsModel != null)
{
DressDetail ObjDressDetails = DBContext.DressDetails.Where(a => a.DressDetails_ID == id).FirstOrDefault();
if (ObjDressDetails != null)
{
//DressDetailsModel Edit Properties mapping here.
//ObjDressDetails.Profile_Name = ObjDressDetailsModel.Profile_Name;
//ObjDressDetails.Password = ObjDressDetailsModel.Password;
//ObjDressDetails.First_Name = ObjDressDetailsModel.First_Name;
//ObjDressDetails.Middle_Name = ObjDressDetailsModel.Middle_Name;
//ObjDressDetails.Last_Name = ObjDressDetailsModel.Last_Name;
//ObjDressDetails.Email_Address = ObjDressDetailsModel.Email_Address;
//ObjDressDetails.Contact_Number = ObjDressDetailsModel.Contact_Number;
//ObjDressDetails.Cell_Number = ObjDressDetailsModel.Cell_Number;
//ObjDressDetails.Location_ID = ObjDressDetailsModel.Location_ID;
//ObjDressDetails.PickUp_Address = ObjDressDetailsModel.PickUp_Address;
//ObjDressDetails.Drop_Address = ObjDressDetailsModel.Drop_Address;
//ObjDressDetails.QR_Code = ObjDressDetailsModel.QR_Code;
//ObjDressDetails.Rating = ObjDressDetailsModel.Rating;
//ObjDressDetails.Created_DateTime = ObjDressDetailsModel.Created_DateTime;
//ObjDressDetails.Created_By = ObjDressDetailsModel.Created_By;
//ObjDressDetails.Modified_DateTime = ObjDressDetailsModel.Modified_DateTime;
//ObjDressDetails.Modified_By = ObjDressDetailsModel.Modified_By;
//ObjDressDetails.Deleted = ObjDressDetailsModel.Deleted;
DBContext.SubmitChanges();
return(ObjDressDetails.DressDetails_ID);
}
else
{
return(WebApiResponse.NoRecordFound);
}
}
else
{
return(WebApiResponse.InputObjectIsNull);
}
}
else
{
return(WebApiResponse.InputIdInvalid);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> GetDressDetails(Guid dressId)
{
var sqlDressImages =
@"SELECT i.ImageId, di.Favourite
FROM DressImages di
JOIN Images i on di.ImageId = i.ImageId
WHERE di.DressId = @DressId
ORDER BY di.SequentialId";
var dressImages =
connection
.Query <DressImageModel>(
sqlDressImages, new { DressId = dressId }, dbTransaction)
.ToList();
var dress =
connection
.QueryFirst <DressQueryModel>(
"Select DressId, DressName, DressWebpage, Price, ProductDescription, DressType, DressApproval, Rating, ShopId, CreatedBy FROM Dresses WHERE DressId = @DressId",
new { DressId = dressId }, dbTransaction);
var image = dressImages.FirstOrDefault(x => x.Favourite);
if (image == null && dressImages.Count > 0)
{
image = dressImages[0];
}
var primaryImageId = image == null ? null : new Guid?(image.ImageId);
var model = new DressDetailsModel()
{
Name = dress.DressName,
DressWebpage = dress.DressWebpage,
Price = dress.Price.ToString("C"),
Shop = dress.ShopId,
Description = dress.ProductDescription,
PrimaryImageId = primaryImageId,
Images = dressImages.Select(x => x.ImageId).ToList(),
Comments = new List <string>()
{
"Love Love Love!",
"So pretty!",
},
Approval = dress.DressApproval.ToString(),
Rating = dress.Rating,
CreatedBy = dress.CreatedBy, //current user
DressType = DressType.Bride,
};
return(View(model));
}
public ActionResult Edit(int id, DressDetailsModel ObjInputDressDetailsModel)
{
//Customized try catch block by Imran Khan. CodeSnippet
try
{
string JsonString = string.Empty;
string ApiURL = OTS.GlobalSettings.WebAPIURL + this.GetType().Name.Replace("Controller", string.Empty) + "/" + System.Reflection.MethodBase.GetCurrentMethod().Name + "/" + id;
int UpdatedDressDetailsId = 0;
UpdatedDressDetailsId = (int)iWebServiceConsumer.ConsumeJsonWebService(ApiURL, ObjInputDressDetailsModel, UpdatedDressDetailsId, OTS.GlobalSettings.WebAPITimeout, out JsonString);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.Error = ex.ToString();
return(View("Error"));
}
}
public int Delete(int id, DressDetailsModel ObjInputDressDetailsModel)
{
try
{
//Just keep ObjInputDressDetailsModel as parameter for Deleted Log.
DressDetail ObjDressDetails = DBContext.DressDetails.Where(a => a.DressDetails_ID == id).FirstOrDefault();
if (ObjDressDetails != null)
{
DBContext.DressDetails.DeleteOnSubmit(ObjDressDetails);
DBContext.SubmitChanges();
return(ObjDressDetails.DressDetails_ID);
}
else
{
return(0);
}
}
catch (Exception ex)
{
throw ex;
}
}