/// <summary>
/// Created By : Ashutosh Dwivedi
/// Created Date : October 19 2018
/// Created For : Add Vendor Type.
/// </summary>
/// <param name="VendorTypeModel"></param>
/// <returns></returns>
public VendorTypeModel SaveVendorType(VendorTypeModel objVendorTypeModel)
{
try
{
string action = "";
//if (objVendorTypeModel.Vendor_Id == 0 && objVendorTypeModel.VendorType == null)
//{
// action = "I";
// var saveVendorType= _workorderems.spSetVendorType(action, objVendorTypeModel.Vendor_Id,
// objVendorTypeModel.VendorType, objVendorTypeModel.Vendor_IsActive);
// objVendorTypeModel.Result = Result.Completed;
//}
if (objVendorTypeModel.VendorType != null)
{
action = "I";
var saveVendorType = _workorderems.spSetVendorType(action, null,
objVendorTypeModel.VendorType, objVendorTypeModel.Vendor_IsActive);
objVendorTypeModel.Result = Result.Completed;
}
else
{
action = "U";
var saveVendorType = _workorderems.spSetVendorType(action, objVendorTypeModel.Vendor_Id,
objVendorTypeModel.VendorType, objVendorTypeModel.Vendor_IsActive);
objVendorTypeModel.Result = Result.UpdatedSuccessfully;
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, " public VendorTypeModel SaveVendorType(VendorTypeModel objVendorTypeModel)", "Exception While Saving Vendor Type.", objVendorTypeModel);
throw;
}
return(objVendorTypeModel);
}
public ActionResult SaveVendorType(VendorTypeModel objVendorTypeModel)
{
eTracLoginModel ObjLoginModel = null;
ViewBag.AccountSection = true;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
}
try
{
var savedStatus = _IVendorType.SaveVendorType(objVendorTypeModel);
if (savedStatus.Result == Result.Completed)
{
ViewBag.Message = CommonMessage.SaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
ModelState.Clear();
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
return(Json(new { Message = ViewBag.Message, AlertMessageClass = ViewBag.AlertMessageClass }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
throw ex;
}
}
internal void Update(VendorTypeModel model)
{
tblVendorType newobj = objData.tblVendorTypes.Where(p => p.VendorTypeId == model.VendorTypeId).FirstOrDefault(); //GetVendorTypes().Where(p => p.VendorTypeId == model.VendorTypeId).FirstOrDefault();
newobj.VendorType = model.VendorType;
if (!string.IsNullOrEmpty(model.TypeImagesPath))
{
newobj.TypeImagesPath = model.TypeImagesPath;
}
objData.SaveChanges();
}
public bool Add(VendorTypeModel vendorType)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var result = connection.Execute(@"INSERT into dbo.VendorType (VendorType)
Values (@VendorType )", vendorType);
return(result == 1);
}
}
public ActionResult AddVendorType()
{
try
{
VendorTypeModel objVendorTypeModel = new VendorTypeModel();
return(PartialView("AddVendorType", objVendorTypeModel));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
throw ex;
}
}
public bool UpdateVendorType(int id, VendorTypeModel vendorType)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
vendorType.id = id;
var result = connection.Execute(@"UPDATE VendorType
SET [VendorType] = @VendorType
WHERE id = @id", vendorType);
return(result == 1);
}
}
public int Save(VendorTypeModel tbl)
{
tblVendorType vendortype = new tblVendorType()
{
IsDelete = false,
VendorType = tbl.VendorType,
VendorTypeId = tbl.VendorTypeId,
TypeImagesPath = tbl.TypeImagesPath,
};
//tbl.IsDelete = false;
objData.tblVendorTypes.Add(vendortype);
objData.SaveChanges();
return(vendortype.VendorTypeId.Value);
}
public ActionResult AddVendorType(VendorTypeModel model)
{
var countries = objOras.GetVendorTypes();
var test = countries.Where(p => p.VendorType.ToUpper() == model.VendorType.ToUpper()).FirstOrDefault();
VendorTypeDetails obj = new VendorTypeDetails();
obj.Status = true;
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.InformationSave : "माहिती सेव केली आहे.";
objOras.Save(model);
int pageindex = 0;
var filter = countries.OrderBy(p => p.VendorTypeId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
obj.VendorTypeList = filter;
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public ActionResult Update(VendorTypeModel model)
{
var countries = objOras.GetVendorTypes();
var test = countries.Where(p => p.VendorType.ToUpper() == model.VendorType.ToUpper()).FirstOrDefault();
VendorTypeDetails obj = new VendorTypeDetails();
//model.TypeImagesPath = SessionManager.GetInstance.ImagePath;
obj.Status = true;
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.UpdateSuccess : "माहितीमध्ये बदल करण्यात आला आहे.";
objOras.Update(model);
int pageindex = 0;
var filter = countries.OrderBy(p => p.VendorTypeId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
obj.VendorTypeList = filter;
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public bool UpdateVendorType(VendorTypeModel model)
{
try
{
var data = tRSEntities4.VendorTypeMasters.Where(x => x.id == model.id && x.isActive == true).FirstOrDefault();
if (data != null)
{
data.Name = model.Name;
tRSEntities4.SaveChanges();
return(true);
}
return(false);
}
catch (Exception e)
{
throw e;
}
}
public bool SaveVendorType(VendorTypeModel model)
{
try
{
VendorTypeMaster vendorType = new VendorTypeMaster()
{
isActive = true,
Name = model.Name,
};
tRSEntities4.VendorTypeMasters.Add(vendorType);
tRSEntities4.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public List <VendorTypeModel> GetVendorTypes()
{
try
{
List <VendorTypeModel> typeModels = new List <VendorTypeModel>();
var data = tRSEntities4.VendorTypeMasters.Where(x => x.isActive == true).ToList();
foreach (var item in data)
{
VendorTypeModel model = new VendorTypeModel
{
id = item.id,
Name = item.Name,
isActive = item.isActive,
};
typeModels.Add(model);
}
return(typeModels);
}
catch (Exception e)
{
throw e;
}
}
public VendorTypeModel GetTypeModel(int id)
{
try
{
var data = tRSEntities4.VendorTypeMasters.Where(x => x.id == id && x.isActive == true).FirstOrDefault();
if (data != null)
{
VendorTypeModel model = new VendorTypeModel();
model.id = data.id;
model.Name = data.Name;
model.isActive = data.isActive;
return(model);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
public IHttpActionResult UpdateVendorType(VendorTypeModel model)
{
var data = typeRepo.UpdateVendorType(model);
return(Ok(data));
}
public IActionResult UpdateTheVendorType(int id, VendorTypeModel vendorType)
{
var result = _storage.UpdateVendorType(id, vendorType);
return(Ok(result));
}
public void AddVendorType(VendorTypeModel vendorType)
{
_storage.Add(vendorType);
}
public ActionResult Edit(int VendorTypeId)
{
VendorTypeModel tbl = objOras.GetVendorTypes().Where(p => p.VendorTypeId == VendorTypeId).FirstOrDefault();
return(Json(tbl, JsonRequestBehavior.AllowGet));
}
