public async Task <ActionResult <InvSupplier> > PostInvSupplier(InvSupplier invSupplier)
{
_context.InvSuppliers.Add(invSupplier);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetInvSupplier", new { id = invSupplier.Id }, invSupplier));
}
public async Task <IActionResult> PutInvSupplier(int id, InvSupplier invSupplier)
{
if (id != invSupplier.Id)
{
return(BadRequest());
}
_context.Entry(invSupplier).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!InvSupplierExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ResponseModel CreateSupplier(InvSupplier aObj)
{
if (aObj.SupplierId == 0)
{
aObj.CreatedDate = DateTime.Now;
_aRepository.Insert(aObj);
_aRepository.Save();
return(_aModel.Respons(true, "New Supplier Details Successfully Saved"));
}
else
{
_aRepository.Update(aObj);
_aRepository.Save();
return(_aModel.Respons(true, "Supplierr Details Successfully Updated"));
}
}
public int update(int id, InvSupplier supplier)
{
SqlParameter[] param = new SqlParameter[9];
param[0] = DataAccess.AddParamter("@Name", supplier.Name, SqlDbType.NVarChar, 500);
param[1] = DataAccess.AddParamter("@Address", supplier.Address, SqlDbType.NVarChar, 500);
param[2] = DataAccess.AddParamter("@Email", supplier.Email, SqlDbType.NVarChar, 500);
param[3] = DataAccess.AddParamter("@Phone", supplier.Phone, SqlDbType.NVarChar, 500);
param[4] = DataAccess.AddParamter("@Remarks", supplier.Remarks, SqlDbType.NVarChar, 500);
param[5] = DataAccess.AddParamter("@Active", supplier.Active, SqlDbType.Int, 50);
param[6] = DataAccess.AddParamter("@ID", id, SqlDbType.Int, 50);
param[7] = DataAccess.AddParamter("@LastModifiedDate", DateTime.Now, SqlDbType.DateTime, 50);
param[8] = DataAccess.AddParamter("@OperatorID", supplier.OperatorID, SqlDbType.Int, 50);
string sql = "Update Inv_Supplier Set Name=@Name,Address=@Address,Email=@Email,Phone=@Phone,Remarks=@Remarks,LastModifiedDate=@LastModifiedDate,OperatorID=@OperatorID,Active=1 Where ID=@ID";
int res = DataAccess.ExecuteSQLNonQuery(sql, param);
return(res);
}
public int insert(InvSupplier supplier)
{
SqlParameter[] param = new SqlParameter[9];
param[0] = DataAccess.AddParamter("@Name", supplier.Name, SqlDbType.NVarChar, 500);
param[1] = DataAccess.AddParamter("@Address", supplier.Address, SqlDbType.NVarChar, 500);
param[2] = DataAccess.AddParamter("@Email", supplier.Email, SqlDbType.NVarChar, 500);
param[3] = DataAccess.AddParamter("@Phone", supplier.Phone, SqlDbType.NVarChar, 500);
param[4] = DataAccess.AddParamter("@Remarks", supplier.Remarks, SqlDbType.NVarChar, 500);
param[5] = DataAccess.AddParamter("@Active", supplier.Active, SqlDbType.Int, 50);
param[6] = DataAccess.AddParamter("@CreationDate", DateTime.Now, SqlDbType.DateTime, 50);
param[7] = DataAccess.AddParamter("@LastModifiedDate", DateTime.Now, SqlDbType.DateTime, 50);
param[4] = DataAccess.AddParamter("@OperatorID", supplier.OperatorID, SqlDbType.Int, 50);
string sql = "Insert Into Inv_Supplier(Name,Address,Email,Phone,Remarks,CreationDate,LastModifiedDate,OperatorID,Active) Values (@Name,@Address,@Email,@Phone,@Remarks,@CreationDate,@LastModifiedDate,@OperatorID,1)";
int res = DataAccess.ExecuteSQLNonQuery(sql, param);
return(res);
}
public InvSupplier get(int id)
{
string sql = "Select * from Inv_Supplier Where ID=" + id.ToString();
DataTable dt = DataAccess.ExecuteSQLQuery(sql);
InvSupplier supplier = new InvSupplier();
supplier.Name = dt.Rows[0]["Name"].ToString();
supplier.Address = dt.Rows[0]["Address"].ToString();
supplier.Email = dt.Rows[0]["Email"].ToString();
supplier.Phone = dt.Rows[0]["Phone"].ToString();
supplier.Remarks = dt.Rows[0]["Remarks"].ToString();
supplier.Active = Convert.ToInt32(dt.Rows[0]["Active"].ToString());
supplier.OperatorID = Convert.ToInt32(dt.Rows[0]["OperatorID"].ToString());
supplier.CreationDate = Convert.ToDateTime(dt.Rows[0]["CreationDate"].ToString());
supplier.LastModifiedDate = Convert.ToDateTime(dt.Rows[0]["LastModifiedDate"].ToString());
return(supplier);
}
public List <InvSupplier> getList()
{
List <InvSupplier> suppliers = new List <InvSupplier>();
string sql = "Select * from Inv_Supplier ";
DataTable dt = DataAccess.ExecuteSQLQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
InvSupplier supplier = new InvSupplier();
supplier.Name = dt.Rows[i]["Name"].ToString();
supplier.Address = dt.Rows[i]["Address"].ToString();
supplier.Email = dt.Rows[i]["Email"].ToString();
supplier.Phone = dt.Rows[i]["Phone"].ToString();
supplier.Remarks = dt.Rows[i]["Remarks"].ToString();
supplier.Active = Convert.ToInt32(dt.Rows[i]["Active"].ToString());
supplier.OperatorID = Convert.ToInt32(dt.Rows[i]["OperatorID"].ToString());
supplier.CreationDate = Convert.ToDateTime(dt.Rows[i]["CreationDate"].ToString());
supplier.LastModifiedDate = Convert.ToDateTime(dt.Rows[i]["LastModifiedDate"].ToString());
suppliers.Add(supplier);
}
return(suppliers);
}
protected void btnSave_Click(object sender, EventArgs e)
{
InvSupplier supplier = new InvSupplier();
supplier.Name = txtName.Text;
supplier.Email = txtmail.Text;
supplier.Phone = txtPhone.Text;
supplier.Remarks = txtRemarks.Text;
supplier.Address = txtAddress.Text;
supplier.Active = 1;
HttpCookie myCookie = Request.Cookies["user"];
supplier.OperatorID = Convert.ToInt32(myCookie.Values["userid"].ToString());
int res = new ClsSupplier().insert(supplier);
if (res > 0)
{
Response.Redirect("~/Inventory/Suppliers.aspx?alert=success");
}
else
{
Response.Redirect("~/Inventory/AddSupplier.aspx?id=0&&alret=notpass");
}
}
public JsonResult CreateSupplier(InvSupplier aObj)
{
var data = _aManager.CreateSupplier(aObj);
return(Json(new { success = data.Status, data }, JsonRequestBehavior.AllowGet));
}
