public JsonResult Insert_SaleTarget(SaleTargetVM SaleTargetVM)
{
bool result = false;
string msg = "Failed to save record..";
result = SaleTargetMethod.Insert_SaleTarget(SaleTargetVM, ref msg);
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public static bool Insert_SaleTarget(SaleTargetVM model, ref string msg)
{
IsSaved = false;
try
{
if (sysfun.IsExist("TargetYear", model.TargetYear, "VehicleSalesTarget", model.DealerCode, " and TargetMonth='" + model.TargetMonth + "' and TargetYear='" + model.TargetYear + "'"))
{
strAutoCode = model.AutoNo;
}
else
{
strAutoCode = sysfun.AutoGen("VehicleSalesTarget", "AutoNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@TargetYear", model.TargetYear), //1
new SqlParameter("@TargetMonth", model.TargetMonth), //2
new SqlParameter("@BrandCode", model.BrandCode), //3
new SqlParameter("@ProdCode", model.ProdCode), //4
new SqlParameter("@VersionCode", model.VersionCode), //5
new SqlParameter("@InvoiceTargetQTY", model.InvoiceTargetQty), //6
new SqlParameter("@BookingTargetQTY", model.BookingTargetQty), //7
new SqlParameter("@AllocationTargetQTY", model.AllocationTargetQty), //8
new SqlParameter("@UpdUser", AuthBase.UserId), //9
new SqlParameter("@UpdTerm", General.CurrentIP), //10
new SqlParameter("@AutoNo", strAutoCode), //10
};
if (sysfun.ExecuteSP_NonQuery("SP_Insert_SaleTarget", param))
{
IsSaved = true;
}
else
{
return(IsSaved);
}
}
catch (Exception ex)
{
//ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
}
return(IsSaved);
}
