public static bool Insert_DealFail(UCS_EvaluationVM model, ref string msg)
{
try
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@EvaluationCode", model.EvaluationCode), //1
new SqlParameter("@IsDealFail", model.IsDealFail), //2
};
if (sysfun.ExecuteSP_NonQuery("sp_IsDealFail_Evaluation", param2))
{
IsSaved = true;
}
else
{
IsSaved = false;
}
}
catch (Exception ex)
{
msg = ex.Message;
IsSaved = false;
}
return(IsSaved);
}
public static bool Insert_PriceOfferNegociation_EvaluationDetail(UCS_EvaluationVM model, string dealerCode)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@EvaluationCode ", strAutoCode), //0
new SqlParameter("@DealerCode ", dealerCode), //1
new SqlParameter("@C_Engine ", Convert.ToDecimal(model.C_Engine)), //2
new SqlParameter("@C_IgnitionSyatem ", Convert.ToDecimal(model.C_IgnitionSyatem)), //3
new SqlParameter("@C_FuelSystem ", Convert.ToDecimal(model.C_FuelSystem)), //4
new SqlParameter("@C_Drivetrain ", Convert.ToDecimal(model.C_Drivetrain)), //5
new SqlParameter("@C_Brakes ", Convert.ToDecimal(model.C_Brakes)), //6
new SqlParameter("@C_Suspension ", Convert.ToDecimal(model.C_Suspension)), //7
new SqlParameter("@C_Steering ", Convert.ToDecimal(model.C_Steering)), //8
new SqlParameter("@C_Electrical ", Convert.ToDecimal(model.C_Electrical)), //9
new SqlParameter("@C_Body ", Convert.ToDecimal(model.C_Body)), //10
new SqlParameter("@C_ACHeater ", Convert.ToDecimal(model.C_ACHeater)), //11
new SqlParameter("@C_OperationOfAccInSecB ", Convert.ToDecimal(model.C_OperationOfAccInSecB)), //12
new SqlParameter("@C_CNGOperation ", Convert.ToDecimal(model.C_CNGOperation)), //13
new SqlParameter("@C_IsEngine ", (model.C_Engine == null ? 'N' : 'Y')), //15
new SqlParameter("@C_IsIgnitionSyatem ", (model.C_IgnitionSyatem == null ? 'N' : 'Y')), //16
new SqlParameter("@C_IsFuelSystem ", (model.C_FuelSystem == null ? 'N' : 'Y')), //17
new SqlParameter("@C_IsDrivetrain ", (model.C_Drivetrain == null ? 'N' : 'Y')), //18
new SqlParameter("@C_IsBrakes ", (model.C_Brakes == null ? 'N' : 'Y')), //19
new SqlParameter("@C_IsSuspension ", (model.C_Suspension == null ? 'N' : 'Y')), //20
new SqlParameter("@C_IsSteering ", (model.C_Steering == null ? 'N' : 'Y')), //21
new SqlParameter("@C_IsElectrical ", (model.C_Electrical == null ? 'N' : 'Y')), //22
new SqlParameter("@C_IsBody ", (model.C_Body == null ? 'N' : 'Y')), //23
new SqlParameter("@C_IsACHeater ", (model.C_ACHeater == null ? 'N' : 'Y')), //24
new SqlParameter("@C_IsOperationOfAccInSecB ", (model.C_IsOperationOfAccInSecB == "" ? 'N' : 'Y')), //25
new SqlParameter("@UpdUser", AuthBase.UserId), //27
new SqlParameter("@Updterm", General.CurrentIP), //27
};
if (sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation_EvaluationDeatail", param, Trans) == true)
{
IsSaved = true;
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
IsSaved = false;
}
//if (sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation_EvaluationDeatail", param))
//{
// IsSaved = true;
//}
}
catch (Exception)
{
throw;
}
ObjTrans.CommittTransaction(ref Trans);
return(IsSaved);
}
public JsonResult Insert_DealFail(UCS_EvaluationVM objects)
{
//string dealerCode = Session["DealerCode"].ToString();
bool result = false;
int count = 0;
string msg = "Failed to save record..";
result = DetailEvaluationMethods.Insert_DealFail(objects, ref msg);
if (result)
{
msg = "Successfully Updated";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public static bool Insert_PriceOfferNegociation(UCS_EvaluationVM model, string dealerCode)
{
try
{
if (string.IsNullOrEmpty(model.EvaluationCode))
{
if (sysfun.IsExist("RegNo", model.RegNo, "UCS_EvaluationMaster", dealerCode))
{
return(IsSaved);
}
strAutoCode = sysfun.AutoGen("UCS_EvaluationMaster", "EvaluationCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
//strAutoCode = sysfun.GetNewMaxID("UCS_EvaluationMaster", "EvaluationCode", 8, dealerCode);
}
else
{
strAutoCode = model.EvaluationCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode ", dealerCode), //0
new SqlParameter("@EvaluationCode ", strAutoCode), //1
new SqlParameter("@EvaluationDate ", sysfun.SaveDate(model.EvaluationDate)), //2
new SqlParameter("@UCSourceCode ", model.UCSourceCode), //3
new SqlParameter("@RegNo ", model.RegNo), //4
new SqlParameter("@RegDate ", sysfun.SaveDate(model.RegDate)), //5
new SqlParameter("@DateOfInspection ", sysfun.SaveDate(model.DateOfInspection)), //6
new SqlParameter("@EngineNo ", model.EngineNo), //7
new SqlParameter("@ChassisNo ", model.ChassisNo), //8
new SqlParameter("@BrandCode ", model.BrandCode), //9
new SqlParameter("@ProdCode ", model.ProdCode), //10
new SqlParameter("@VersionCode ", model.VersionCode), //11
new SqlParameter("@ColorCode", model.ColorCode), //12
new SqlParameter("@CusCode ", model.CusCode), //13
new SqlParameter("@TransmissionType ", model.TransmissionType), //14
new SqlParameter("@UserName ", model.UserName), //15
new SqlParameter("@OfferCategory ", model.OfferCategory), //16
new SqlParameter("@CurrentMilage ", model.CurrentMilage), //17
new SqlParameter("@CustomerExpectedPrice", model.CustomerExpectedPrice), //18
new SqlParameter("@ExpectationCustomer ", model.ExpectationCustomer), //19
new SqlParameter("@BuyingPriceOffer ", model.BuyingPriceOffer), //20
new SqlParameter("@ReCondition ", model.ReCondition), //21
new SqlParameter("@UCSourceRemarks ", model.UCSourceRemarks), //22
new SqlParameter("@UpdUser", AuthBase.UserId), //23
new SqlParameter("@UpdTerm", General.CurrentIP), //24
new SqlParameter("@IsVerificationFromCPLC ", model.IsVerificationFromCPLC), //25
new SqlParameter("@RegistrationBook", model.RegistrationBook), //26
new SqlParameter("@SaleInvoice", model.SaleInvoice), //27
new SqlParameter("@ExchangeType", (model.OfferCategory == "Exchange" ? 'Y' : 'N')), //27
new SqlParameter("@CellNo ", model.CellNo), //21
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation", param, Trans);
IsSaved = true;
}
//if (sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation", param))
//{
// IsSaved = true;
//}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
