/// <summary>
/// Add Update Data
/// </summary>
/// <param name="model"></param>
/// <returns>Jsonresponse</returns>
public JsonResponse AddUpdate(ProductTypeMaster model)
{
try
{
// If these condition true the data was not exsits in the database
if (!IsExsits(model.Name, model.ID))
{
// If model.ID == 0 the data goes to the Add part.
if (model.ID == 0)
{
model.CreatedOn = DateTime.Now;
model.CreatedBy = GetUserID();
_context.Set <ProductTypeMaster>().Add(model);
int i = _context.SaveChanges();
if (i != 0)
{
resp.Status = Constants.ResponseStatus.Success;
resp.Message = Constants.Service.Data_insert_success;
}
else
{
resp.Message = Constants.Service.Data_insert_failed;
}
}
// Else data goes to the Update part.
else
{
var models = GetData(model.ID);
if (models != null)
{
models.Name = model.Name;
models.Code = model.Code;
models.ProductDescription = model.ProductDescription;
models.ProductKYCDescription = model.ProductKYCDescription;
models.IsActive = model.IsActive;
models.ModifiedOn = DateTime.Now;
models.ModifiedBy = GetUserID();
_context.Set <ProductTypeMaster>().Update(models);
int i = _context.SaveChanges();
if (i != 0)
{
resp.Status = Constants.ResponseStatus.Success;
resp.Message = Constants.Service.Data_Update_success;
}
}
}
}
// The data was in the database so, It return the else part
else
{
resp.Message = Constants.ControllerMessage.Data_Exsists;
}
}
catch (Exception)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public void InsertProductType(ProductTypeMaster ProductType)
{
ProductType.Deactivate = "N";
ProductType.EnteredBy = 10;
ProductType.EntryDate = DateTime.Now;
ProductType.ModifiedBy = null;
ProductType.ModifiedDate = null;
ProductType.DeactivateBy = null;
ProductType.DeactivateDate = null;
_ProductTypeRepository.Insert(ProductType);
}
public IHttpActionResult GetISBNList(ProductTypeMaster Ptype)
{
var _list = _CommonListService.GetAllISBNByProductTypeId(Ptype.Id).Where(a => a.Blocked == null).ToList();
var query = _list.Select(i => new
{
Id = i.Id,
ISBN = i.ISBN,
}).OrderBy(a => a.Id);
return(Json(SerializeObj.SerializeObject(new { query })));
}
//Added by sanjeet on 16th may 2016
public IHttpActionResult InsertProductType(ProductTypeMaster ProductType)
{
string status = "";
try
{
if (ProductType.parenttypeid == null)
{
ProductType.typelevel = 1;
}
else
{
ProductType.typelevel = 2;
}
status = _productTypeService.DuplicityCheck(ProductType);
if (status == "Y")
{
if (ProductType.Id == 0)
{
_productTypeService.InsertProductType(ProductType);
}
else
{
ProductTypeMaster mobj_producttype = _productTypeService.GetProductTypeById(ProductType);
mobj_producttype.typeName = ProductType.typeName;
mobj_producttype.typelevel = ProductType.typelevel;
mobj_producttype.parenttypeid = ProductType.parenttypeid;
mobj_producttype.ModifiedBy = ProductType.EnteredBy;
mobj_producttype.ModifiedDate = System.DateTime.Now;
_productTypeService.UpdateProductType(mobj_producttype);
}
status = _localizationService.GetResource("Master.API.Success.Message");
}
else
{
status = "Duplicate";
}
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
/// <summary>
/// Check The duplicity of record before insertion and deletion
/// </summary>
/// <param name="GeographyType">Geography</param>
public string DuplicityCheck(ProductTypeMaster ProductType)
{
var dupes = _ProductTypeRepository.Table.Where(x => x.typeName == ProductType.typeName &&
x.Deactivate == "N" &&
(ProductType.Id != 0 ? x.Id : 0) != (ProductType.Id != 0 ? ProductType.Id : 1)).FirstOrDefault();
if (dupes != null)
{
return("N");
}
else
{
return("Y");
}
}
public IHttpActionResult ProductTypeDelete(ProductTypeMaster _productType)
{
string status = string.Empty;
try
{
ProductTypeMaster productType = _productTypeService.GetProductTypeById(_productType);
productType.Deactivate = "Y";
productType.DeactivateBy = _productType.EnteredBy;
productType.DeactivateDate = DateTime.Now;
_productTypeService.UpdateProductType(productType);
status = "OK";
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
public void DeleteProductType(ProductTypeMaster ProductType)
{
_ProductTypeRepository.Delete(ProductType);
}
public void UpdateProductType(ProductTypeMaster ProductType)
{
_ProductTypeRepository.Update(ProductType);
}
public ProductTypeMaster GetProductTypeById(ProductTypeMaster ProductType)
{
return(_ProductTypeRepository.Table.Where(i => i.Id == ProductType.Id).FirstOrDefault());
}
public IHttpActionResult ProductType(ProductTypeMaster _productType)
{
ProductTypeMaster productType = _productTypeService.GetProductTypeById(_productType);
return(Json(productType));
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objProductType = null;
}
/// <summary>
/// create by Vishal Verma on 12/05/2016
/// Gets all Sub ProductType by ProductType Id WISE
/// </summary>
/// <param name="showDeactivated">A value indicating whether to show hidden records</param>
/// <returns>ProductType collection</returns>
public virtual IList <ProductTypeMaster> GetAllSubProductType(ProductTypeMaster ProductType)
{
return(_ProductTypeRepository.Table.Where(d => d.parenttypeid == ProductType.Id && d.Deactivate == "N").OrderBy(c => c.typeName).ToList());
}
/// <summary>
/// Description :getSubProductTypeList
/// Function Name :getSubProductTypeList
/// OutPut parameter :Json Object
/// Create Date : 12 May 2016
/// Author Name : Vishal Verma
/// </summary>
/// <remarks>
///**************************** Modification History *************************************************************
/// Sr No: Date Modified by Tracker Description
///*****************************************************************************************************************
///*****************************************************************************************************************
///
///</remarks>
///
public IHttpActionResult SubProductTypeList(ProductTypeMaster ProductType)
{
return(Json(_CommonListService.GetAllSubProductType(ProductType).ToList()));
}
