public ActionResult InsertQuotation()
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
if (ModelState.IsValid)
{
int AAVECID = Convert.ToInt32(Request.Form["AAVECID"]);
tblAlbumAndVideoEditingCharge AAVEC = db.tblAlbumAndVideoEditingCharges.SingleOrDefault(A => A.AlbumAndVideoEditingChargesID == AAVECID);
tblQuotation quotation = new tblQuotation();
quotation.AlbumAndVideoEditingChargesID = AAVECID;
quotation.EventDate = Convert.ToDateTime(Request.Form["EventDate"]);
quotation.FunctionName = Request.Form["FunctionName"];
quotation.CandidCinematographers = string.IsNullOrEmpty(Request.Form["CandidCinemato"])? 0 : Convert.ToInt32(Request.Form["CandidCinemato"]);
quotation.RegularCinematographers = string.IsNullOrEmpty(Request.Form["RegularCinemato"]) ? 0 : Convert.ToInt32(Request.Form["RegularCinemato"]);
quotation.CandidPhotographer = string.IsNullOrEmpty(Request.Form["CandidPhoto"]) ? 0 : Convert.ToInt32(Request.Form["CandidPhoto"]);
quotation.RegularPhotographer = string.IsNullOrEmpty(Request.Form["RegularPhoto"]) ? 0 : Convert.ToInt32(Request.Form["RegularPhoto"]);
quotation.DSLR = string.IsNullOrEmpty(Request.Form["DSLR"]) ? 0 : Convert.ToInt32(Request.Form["DSLR"]);
quotation.NumberOfDrones = string.IsNullOrEmpty(Request.Form["Drones"]) ? 0 : Convert.ToInt32(Request.Form["Drones"]);
quotation.NumberOfLedScreens = string.IsNullOrEmpty(Request.Form["LEDScreen"]) ? 0 : Convert.ToInt32(Request.Form["LEDScreen"]);
quotation.Others = string.IsNullOrEmpty(Request.Form["Other"]) ? string.Empty : Request.Form["Other"];
quotation.TotalAmount = Convert.ToDecimal(Request.Form["TotalAmount"]);
if (AAVEC.IsDisscount == true)
{
AAVEC.OriginalAmount += Convert.ToDecimal(quotation.TotalAmount);
decimal DiscountedAmount = (Convert.ToDecimal(AAVEC.OriginalAmount) * Convert.ToDecimal(AAVEC.DiscountPercentage)) / 100;
AAVEC.DiscountedAmount = DiscountedAmount;
AAVEC.FinalAmount = AAVEC.OriginalAmount - DiscountedAmount;
}
else
{
AAVEC.OriginalAmount += Convert.ToDecimal(quotation.TotalAmount);
AAVEC.FinalAmount = AAVEC.OriginalAmount;
}
quotation.CreatedDate = DateTime.Now;
db.Entry(AAVEC).State = EntityState.Modified;
db.SaveChanges();
db.tblQuotations.Add(quotation);
db.SaveChanges();
return(Json(new { success = true, message = "Record inserted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Record is not inserted!" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error! " + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateAlbumAndVideoEditingCharge()
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
if (ModelState.IsValid)
{
int AAVECID = Convert.ToInt32(Request.Form["AAVECID"]);
tblAlbumAndVideoEditingCharge AAVEC = db.tblAlbumAndVideoEditingCharges.SingleOrDefault(AA => AA.AlbumAndVideoEditingChargesID == AAVECID);
AAVEC.AlbumPage = Convert.ToInt32(Request.Form["AlbumPage"]);
AAVEC.AlbumSize = Request.Form["AlbumSize"];
AAVEC.AlbumPrice = Convert.ToDecimal(Request.Form["AlbumPrice"]);
AAVEC.AlbumPadSize = Request.Form["AlbumPadSize"];
AAVEC.AlbumPadPrice = Convert.ToDecimal(Request.Form["AlbumPadPrice"]);
AAVEC.PhotoLEDFramePrice = Convert.ToDecimal(Request.Form["PhotoLEDFramePrice"]);
AAVEC.SpecialAlbum = Convert.ToDecimal(Request.Form["SpecialAlbum"]);
AAVEC.HDVideoDubbPendrivePrice = Convert.ToDecimal(Request.Form["HDVideoDubbPendrivePrice"]);
AAVEC.Other = Request.Form["Other"];
AAVEC.IsDisscount = Request.Form["IsDisscount"] == "true" ? true : false;
if (AAVEC.IsDisscount != true)
{
AAVEC.DiscountPercentage = 0;
AAVEC.DiscountedAmount = 0;
AAVEC.FinalAmount = AAVEC.OriginalAmount;
}
else
{
AAVEC.DiscountPercentage = string.IsNullOrEmpty(Request.Form["DiscountPercentage"]) ? 0 : Convert.ToInt32(Request.Form["DiscountPercentage"]);
AAVEC.OriginalAmount = string.IsNullOrEmpty(Request.Form["OriginalAmount"]) ? 0 : Convert.ToDecimal(Request.Form["OriginalAmount"]);
AAVEC.DiscountedAmount = Convert.ToDecimal(Request.Form["DiscountedAmount"]);
AAVEC.FinalAmount = Convert.ToDecimal(Request.Form["FinalAmount"]);
}
AAVEC.UpdatedDate = DateTime.Now;
db.Entry(AAVEC).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Record updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Record is not updated!" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error! " + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ManageQuotationDetails(int?id)
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblAlbumAndVideoEditingCharge AAVEC = db.tblAlbumAndVideoEditingCharges.SingleOrDefault(A => A.AlbumAndVideoEditingChargesID == id);
ViewBag.AAVECID = AAVEC.AlbumAndVideoEditingChargesID;
ViewBag.IsDisscount = AAVEC.IsDisscount;
ViewBag.IsPass = AAVEC.IsPass == true ? true : false;
return(View(db.tblQuotations.Where(Q => Q.AlbumAndVideoEditingChargesID == id)));
}
public ActionResult UpdateAlbumAndVideoEditingCharge(int?id)
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblAlbumAndVideoEditingCharge AAVEC = db.tblAlbumAndVideoEditingCharges.Find(id);
if (AAVEC == null)
{
return(HttpNotFound());
}
return(View(AAVEC));
}
public ActionResult DeleteAlbumAndVideoEditing(int id)
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
tblAlbumAndVideoEditingCharge tblAlbumAndVideoEditing = db.tblAlbumAndVideoEditingCharges.Find(id);
db.tblAlbumAndVideoEditingCharges.Remove(tblAlbumAndVideoEditing);
db.SaveChanges();
return(Json(new { success = true, message = "Record deleted successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error!" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult PrintQuotation(int?id)
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblAlbumAndVideoEditingCharge AAVEC = db.tblAlbumAndVideoEditingCharges.Find(id);
if (AAVEC == null)
{
return(HttpNotFound());
}
tblAlbumAndVideoEditingCharge AAVECDetails = db.tblAlbumAndVideoEditingCharges.SingleOrDefault(A => A.AlbumAndVideoEditingChargesID == id);
ViewBag.CustomerName = AAVECDetails.tblCustomer.CustomerName;
ViewBag.AAVECID = AAVECDetails.AlbumAndVideoEditingChargesID;
return(View(db.tblQuotations.Where(Q => Q.AlbumAndVideoEditingChargesID == id)));
}
public ActionResult ChangeIsPassStatus()
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
int id = Convert.ToInt32(Request.Form["id"]);
int Flag = Convert.ToInt32(Request.Form["flag"]);
tblAlbumAndVideoEditingCharge TAAVEC = db.tblAlbumAndVideoEditingCharges.SingleOrDefault(Q => Q.AlbumAndVideoEditingChargesID == id);
TAAVEC.UpdatedDate = DateTime.Now;
if (Flag >= 1)
{
TAAVEC.IsPass = true;
}
else
{
TAAVEC.IsPass = false;
}
db.Entry(TAAVEC).State = EntityState.Modified;
db.SaveChanges();
if (Flag >= 1)
{
return(Json(new { Approved = true, message = "Quotation is Approved" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Approved = true, message = "Quotation is not Approved" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { Error = false, message = "Error!" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteQuotation(int id)
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
tblQuotation quotation = db.tblQuotations.Find(id);
long AAVECID = Convert.ToInt64(quotation.AlbumAndVideoEditingChargesID);
tblAlbumAndVideoEditingCharge AAVEC = db.tblAlbumAndVideoEditingCharges.SingleOrDefault(A => A.AlbumAndVideoEditingChargesID == AAVECID);
if (AAVEC.IsDisscount == true)
{
AAVEC.OriginalAmount -= Convert.ToDecimal(quotation.TotalAmount);
decimal DiscountedAmount = (Convert.ToDecimal(AAVEC.OriginalAmount) * Convert.ToDecimal(AAVEC.DiscountPercentage)) / 100;
AAVEC.DiscountedAmount = DiscountedAmount;
AAVEC.FinalAmount = AAVEC.OriginalAmount - DiscountedAmount;
}
else
{
AAVEC.OriginalAmount -= Convert.ToDecimal(quotation.TotalAmount);
AAVEC.FinalAmount -= Convert.ToDecimal(quotation.TotalAmount);
}
db.Entry(AAVEC).State = EntityState.Modified;
db.SaveChanges();
db.tblQuotations.Remove(quotation);
db.SaveChanges();
return(Json(new { success = true, message = "Record deleted successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error!" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult InsertAlbumAndVideoEditingCharge()
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
long LastAAVECID = 0;
try
{
if (ModelState.IsValid)
{
tblAlbumAndVideoEditingCharge AAVEC = new tblAlbumAndVideoEditingCharge();
AAVEC.CustomerID = Convert.ToInt64(Request.Form["CustomerID"]);
if (IsQuotationIsExist(Convert.ToInt64(AAVEC.CustomerID)))
{
return(Json(new { success = false, message = "Quotation of this user is already created!" }, JsonRequestBehavior.AllowGet));
}
AAVEC.AlbumPage = Convert.ToInt32(Request.Form["AlbumPage"]);
AAVEC.AlbumSize = Request.Form["AlbumSize"];
AAVEC.AlbumPrice = Convert.ToDecimal(Request.Form["AlbumPrice"]);
AAVEC.AlbumPadSize = Request.Form["AlbumPadSize"];
AAVEC.AlbumPadPrice = Convert.ToDecimal(Request.Form["AlbumPadPrice"]);
AAVEC.PhotoLEDFramePrice = Convert.ToDecimal(Request.Form["PhotoLEDFramePrice"]);
AAVEC.SpecialAlbum = Convert.ToDecimal(Request.Form["SpecialAlbum"]);
AAVEC.HDVideoDubbPendrivePrice = Convert.ToDecimal(Request.Form["HDVideoDubbPendrivePrice"]);
AAVEC.Other = Request.Form["Other"];
AAVEC.IsDisscount = Request.Form["IsDisscount"] == "true" ? true : false;
AAVEC.OriginalAmount = string.IsNullOrEmpty(Request.Form["OriginalAmount"]) ? 0 : Convert.ToDecimal(Request.Form["OriginalAmount"]);
if (AAVEC.IsDisscount != true)
{
AAVEC.DiscountPercentage = 0;
AAVEC.DiscountedAmount = 0;
AAVEC.FinalAmount = AAVEC.OriginalAmount;
}
else
{
AAVEC.DiscountPercentage = string.IsNullOrEmpty(Request.Form["DiscountPercentage"]) ? Convert.ToInt64(0) : Convert.ToInt64(Request.Form["DiscountPercentage"]);
AAVEC.DiscountedAmount = Convert.ToDecimal(Request.Form["DiscountedAmount"]);
AAVEC.FinalAmount = Convert.ToDecimal(Request.Form["FinalAmount"]);
}
AAVEC.IsPass = false;
AAVEC.CreatedDate = DateTime.Now;
db.tblAlbumAndVideoEditingCharges.Add(AAVEC);
db.SaveChanges();
LastAAVECID = db.tblAlbumAndVideoEditingCharges.Max(item => item.AlbumAndVideoEditingChargesID);;
return(Json(new { success = true, message = "Record inserted successfully", lastAAVECID = LastAAVECID }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Record is not inserted!" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error! " + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
