public JsonResult GetAllSuppliers()
{
var currentUser = (dtoUserAccount)Session["CurrentUser"];
var page = int.Parse(Request["page"]);
var recordPerPage = int.Parse(Request["recordPerPage"]);
var isExport = false;
var filter = new dtoSupplier
{
supplierCode = Request["supplierCode"],
supplierName = Request["supplierName"],
supplierContactNumber = Request["supplierContactNumber"],
supplierContactPerson = Request["supplierContactPerson"],
branchId = currentUser.branchId
};
var list = serviceSupplier.GetAllSuppliers(page, recordPerPage, filter, isExport);
var ret = Json(list);
return ret;
}
public JsonResult AddEditSupplier(dtoSupplier supplier)
{
dtoResult result;
var currentUser = (dtoUserAccount)Session["CurrentUser"];
if (supplier.supplierId == 0)
{
supplier.branchId = currentUser.branchId;
supplier.createdBy = currentUser.userId;
supplier.dateCreated = DateTime.Now;
result = serviceSupplier.Insert(supplier);
}
else
{
supplier.modifiedBy = currentUser.userId;
supplier.dateLastModified = DateTime.Now;
result = serviceSupplier.Update(supplier);
}
return Json(result);
}
public dtoSupplier Get(dtoSupplier t)
{
string sQuery = string.Format(@"SELECT [supplierId]
,[supplierCode]
,[supplierName]
,[supplierAddress]
,[supplierContactNumber]
,[supplierContactPerson]
,[branchId]
,[status]
,[dateCreated]
,[createdBy]
FROM tbl_supplier
WHERE (1 = 1)");
sQuery += string.Format(" AND ('{0}' = '' OR supplierCode = '{0}' )", t.supplierCode);
sQuery += string.Format(" AND ('{0}' = '' OR supplierName = '{0}' )", t.supplierName);
sQuery += string.Format(" AND ('{0}' = '' OR supplierContactNumber = '{0}' )", t.supplierContactNumber);
sQuery += string.Format(" AND ('{0}' = '' OR supplierContactPerson = '{0}' )", t.supplierContactPerson);
sQuery += string.Format(" AND ({0} = {0} OR [status] = {0})", t.status);
return DBContext.Database.SqlQuery<dtoSupplier>(sQuery).FirstOrDefault();
}
public JsonResult Save(dtoSupplier objSupplier)
{
/* Live */
//objUserAccount = (dtoUserAccount)Session["CurrentUser"];
//if (objSupplier.supplierId < 1)
// objSupplier.createdBy = objUserAccount.userId;
//else if (objSupplier.supplierId > 0)
// objSupplier.modifiedBy = objUserAccount.userId;
/* Test */
if(objSupplier.supplierId < 1)
objSupplier.createdBy = 1;
else if (objSupplier.supplierId > 0)
objSupplier.modifiedBy = 2;
return Json(serviceSupplier.Save(objSupplier));
}
public dtoResult Update(dtoSupplier t)
{
dtoResult objResult = new dtoResult();
List<object> parameterList = new List<object>();
object[] parameters1 = null;
try
{
string sQuery = string.Format(@"UPDATE tbl_supplier SET supplierCode = @P0,supplierName = @P1,supplierAddress=@P2,supplierContactNumber=@P3,supplierContactPerson=@P4,[status]=@P5,modifiedBy=@P6,dateLastModified=GETDATE()
WHERE supplierId=@P7");
parameterList.Add(t.supplierCode);
parameterList.Add(t.supplierName);
parameterList.Add(t.supplierAddress);
parameterList.Add(t.supplierContactNumber);
parameterList.Add(t.supplierContactPerson);
parameterList.Add(t.status);
parameterList.Add(t.modifiedBy);
parameterList.Add(t.supplierId);
parameters1 = parameterList.ToArray();
DBContext.Database.ExecuteSqlCommand(sQuery, parameters1);
objResult.isSuccessful = true;
}
catch (Exception ex)
{
objResult.isSuccessful = false;
objResult.errorMsg = ex.Message;
}
parameterList = null;
parameters1 = null;
return objResult;
}
public dtoResult SoftDelete(dtoSupplier t)
{
throw new NotImplementedException();
}
public dtoResult Insert(dtoSupplier t)
{
dtoResult objResult = new dtoResult();
List<object> parameterList = new List<object>();
object[] parameters1 = null;
try
{
string sQuery = string.Format(@"INSERT INTO tbl_supplier(supplierCode,supplierName,supplierAddress,supplierContactNumber,supplierContactPerson,[status],createdBy,dateCreated,branchId)
VALUES(@P0,@P1,@P2,@P3,@P4,@P5,@P6,GETDATE(),@P7)");
parameterList.Add(t.supplierCode);
parameterList.Add(t.supplierName);
parameterList.Add(t.supplierAddress);
parameterList.Add(t.supplierContactNumber);
parameterList.Add(t.supplierContactPerson);
parameterList.Add(t.status);
parameterList.Add(t.createdBy);
parameterList.Add(t.branchId);
parameters1 = parameterList.ToArray();
DBContext.Database.ExecuteSqlCommand(sQuery, parameters1);
objResult.isSuccessful = true;
}
catch (Exception ex)
{
objResult.isSuccessful = false;
objResult.errorMsg = ex.Message;
}
parameterList = null;
parameters1 = null;
return objResult;
}
public dtoResult Update(dtoSupplier supplier)
{
return repo.Update(supplier);
}
public dtoResult Save(dtoSupplier objSupplier)
{
dtoResult objResult = new dtoResult();
dtoSupplier objValidation;
try
{
if (objSupplier == null)
throw new Exception("Please provide valid Supplier details.");
objSupplier.supplierCode = ("" + objSupplier.supplierCode).Trim();
objSupplier.supplierName = ("" + objSupplier.supplierName).Trim();
if (objSupplier.supplierCode == string.Empty)
throw new Exception("Please provide valid Supplier Code.");
if (objSupplier.supplierName == string.Empty)
throw new Exception("Please provide valid Supplier Name.");
if (objSupplier.supplierId == 0)
{
if (objSupplier.createdBy < 1)
throw new Exception("Please provide valid User ID.");
objValidation = repo.GetByCode(objSupplier.supplierCode);
if (objValidation != null)
throw new Exception("Cannot be saved because Supplier Code already exists.");
objValidation = null;
objValidation = repo.GetByName(objSupplier.supplierName);
if (objValidation != null)
throw new Exception("Cannot be saved because Suppier Name already exists.");
objResult = repo.Insert(objSupplier);
}
else
{
if (objSupplier.modifiedBy < 1)
throw new Exception("Please provide valid User ID.");
objResult = repo.Update(objSupplier);
}
}
catch (Exception ex)
{
objResult.isSuccessful = false;
objResult.errorMsg = ex.Message;
}
objValidation = null;
return objResult;
}
public dtoResult Insert(dtoSupplier supplier)
{
return repo.Insert(supplier);
}
