public void BindProducts(Int64 ProductId)
{
rawMaterialMaster objproduct = (new Cls_Rawmaterial_b().SelectById(ProductId));
if (objproduct != null)
{
txtProductName.Text = objproduct.productname;
txthsncode.Text = objproduct.hsncode;
txtgstno.Text = objproduct.gstno;
txtPrice.Text = objproduct.price.ToString();
ddlunit.SelectedIndex = objproduct.unitid;
txtQuantites.Text = objproduct.quantity.ToString();
txtAlertQuantites.Text = objproduct.alertquantites.ToString();
cbIsStock.Checked = objproduct.isstock;
txtProductShortDescription.Text = objproduct.shortdescp;
txtProductDescription.Text = objproduct.longdescp;
if (!string.IsNullOrEmpty(objproduct.mainimage))
{
imgProduct.Visible = true;
ViewState["fileName"] = objproduct.mainimage;
imgProduct.ImageUrl = productFrontPath + objproduct.mainimage;
btnImageUpload.Visible = false;
btnRemove.Visible = true;
}
else
{
//btnImageUpload.Visible = true;
}
}
}
public rawMaterialMaster SelectById(Int64 pid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
rawMaterialMaster objrawMaterialMaster = new rawMaterialMaster();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "raw_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@id", pid);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
objrawMaterialMaster.id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
objrawMaterialMaster.productname = Convert.ToString(ds.Tables[0].Rows[0]["productname"]);
objrawMaterialMaster.mainimage = Convert.ToString(ds.Tables[0].Rows[0]["mainimage"]);
objrawMaterialMaster.price = Convert.ToDecimal(ds.Tables[0].Rows[0]["price"]);
objrawMaterialMaster.hsncode = Convert.ToString(ds.Tables[0].Rows[0]["hsncode"]);
objrawMaterialMaster.gstno = Convert.ToString(ds.Tables[0].Rows[0]["gstno"]);
objrawMaterialMaster.quantity = Convert.ToInt32(ds.Tables[0].Rows[0]["quantity"]);
objrawMaterialMaster.unitid = Convert.ToInt32(ds.Tables[0].Rows[0]["unitid"]);
objrawMaterialMaster.alertquantites = Convert.ToInt32(ds.Tables[0].Rows[0]["alertquantites"]);
objrawMaterialMaster.isstock = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isstock"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isstock"]);
objrawMaterialMaster.shortdescp = Convert.ToString(ds.Tables[0].Rows[0]["shortdescp"]);
objrawMaterialMaster.longdescp = Convert.ToString(ds.Tables[0].Rows[0]["longdescp"]);
objrawMaterialMaster.isactive = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isactive"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isactive"]);
objrawMaterialMaster.isdelete = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isdelete"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isdelete"]);
objrawMaterialMaster.createddate = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["createddate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["createddate"]);
objrawMaterialMaster.modifieddate = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["modifieddate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["modifieddate"]);
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objrawMaterialMaster);
}
public Int64 Update(rawMaterialMaster objrawMaterialMaster)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "rawMaterial_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objrawMaterialMaster.id;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@productname", objrawMaterialMaster.productname);
cmd.Parameters.AddWithValue("@mainimage", objrawMaterialMaster.mainimage);
cmd.Parameters.AddWithValue("@price", objrawMaterialMaster.price);
cmd.Parameters.AddWithValue("@quantity", objrawMaterialMaster.quantity);
cmd.Parameters.AddWithValue("@alertquantites", objrawMaterialMaster.alertquantites);
cmd.Parameters.AddWithValue("@isstock", objrawMaterialMaster.isstock);
cmd.Parameters.AddWithValue("@shortdescp", objrawMaterialMaster.shortdescp);
cmd.Parameters.AddWithValue("@longdescp", objrawMaterialMaster.longdescp);
cmd.Parameters.AddWithValue("@hsncode", objrawMaterialMaster.hsncode);
cmd.Parameters.AddWithValue("@gstno", objrawMaterialMaster.gstno);
cmd.Parameters.AddWithValue("@unitid", objrawMaterialMaster.unitid);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
/*
* private String _productname;
* private String _mainimage;
* private Decimal _price;
* private Int32 _quantity;
* private Int32 _alertquantites;
* private Boolean _isstock;
* private String _shortdescp;
* private String _longdescp;
* private Boolean _isactive;
* private Boolean _isdelete;
* private System.DateTime _createddate;
* private System.DateTime _modifieddate;
* private String _hsncode;
* private String _gstno;
* private Int32 _unitid; */
Int64 Result = 0;
//product objproduct = new product();
rawMaterialMaster objrawmaterial = new rawMaterialMaster();
objrawmaterial.productname = txtProductName.Text.Trim();
objrawmaterial.price = Convert.ToDecimal(txtPrice.Text.Trim());
objrawmaterial.quantity = Convert.ToInt32(txtQuantites.Text.Trim());
objrawmaterial.alertquantites = Convert.ToInt32(txtAlertQuantites.Text.Trim());
objrawmaterial.isstock = cbIsStock.Checked;
objrawmaterial.shortdescp = txtProductShortDescription.Text;
objrawmaterial.longdescp = txtProductDescription.Text;
objrawmaterial.hsncode = txthsncode.Text.Trim();
objrawmaterial.gstno = txtgstno.Text.Trim();
objrawmaterial.unitid = Convert.ToInt32(ddlunit.SelectedValue);
if (ViewState["fileName"] != null)
{
objrawmaterial.mainimage = ViewState["fileName"].ToString();
}
if (Request.QueryString["id"] != null)
{
objrawmaterial.id = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_Rawmaterial_b().Update(objrawmaterial));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/manageRawMaterial.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Update Failed...";
BindProducts(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_Rawmaterial_b().Insert(objrawmaterial));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/manageRawMaterial.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Raw Material Not Saved";
}
}
}
