/*
* public DataTable SelectAll_Admin()
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "articleproduction_SelectAllAdmin";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
* ConnectionString.Open();
* da = new SqlDataAdapter(cmd);
* da.Fill(ds);
* }
* catch (Exception ex)
* {
* ErrHandler.writeError(ex.Message, ex.StackTrace);
* return null;
* }
* finally
* {
* ConnectionString.Close();
* }
* return ds.Tables[0];
* }
*
* public DataTable SelectAll()
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "articleproduction_SelectAll";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
* ConnectionString.Open();
* da = new SqlDataAdapter(cmd);
* da.Fill(ds);
* }
* catch (Exception ex)
* {
* ErrHandler.writeError(ex.Message, ex.StackTrace);
* return null;
* }
* finally
* {
* ConnectionString.Close();
* }
* return ds.Tables[0];
* }
*
* public articleproduction SelectById(Int64 bankid)
* {
* SqlDataAdapter da;
* DataSet ds = new DataSet();
* articleproduction objarticleproduction = new articleproduction();
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "articleproduction_SelectById";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
* cmd.Parameters.AddWithValue("@bankid", bankid);
* 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)
* {
* {
*
* objarticleproduction.bankid = Convert.ToInt32(ds.Tables[0].Rows[0]["bankid"]);
* objarticleproduction.bankname = Convert.ToString(ds.Tables[0].Rows[0]["bankname"]);
* objarticleproduction.bankifsccode = Convert.ToString(ds.Tables[0].Rows[0]["bankifsccode"]);
* objarticleproduction.bankbranch = Convert.ToString(ds.Tables[0].Rows[0]["bankbranch"]);
* objarticleproduction.accountno = Convert.ToString(ds.Tables[0].Rows[0]["accountno"]);
* objarticleproduction.accountholdername = Convert.ToString(ds.Tables[0].Rows[0]["accountholdername"]);
* objarticleproduction.balance = Convert.ToDecimal(ds.Tables[0].Rows[0]["balance"]);
*
* }
* }
* }
* }
* }
* }
* catch (Exception ex)
* {
* ErrHandler.writeError(ex.Message, ex.StackTrace);
* return null;
* }
* finally
* {
* ConnectionString.Close();
* }
* return objarticleproduction;
* }
*
*/
public Int64 Insert(articleproduction objarticleproduction)
{
//id, worksheetno, employeeid, totalpairs, vshape, silai, factorysecond, isdeleted, createddate
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "articleproduction_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objarticleproduction.id;
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@worksheetno", objarticleproduction.worksheetno);
cmd.Parameters.AddWithValue("@employeeid", objarticleproduction.employeeid);
cmd.Parameters.AddWithValue("@totalpairs", objarticleproduction.totalpairs);
cmd.Parameters.AddWithValue("@vshape", objarticleproduction.vshape);
cmd.Parameters.AddWithValue("@silai", objarticleproduction.silai);
cmd.Parameters.AddWithValue("@factorysecond", objarticleproduction.factorysecond);
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 ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
* {
* Int64 id = Int64.Parse(ddlCategory.SelectedValue.ToString());
* try
* {
* product objProduct = new product();
* Cls_product_b clsProduct = new Cls_product_b();
* dtProduct = clsProduct.Product_WSSelectAllProductUsingCategoryId(id);
* if (dtProduct != null)
* {
* if (dtProduct.Rows.Count > 0)
* {
* //ddlProduct.DataSource = dtProduct;
* //ddlProduct.DataTextField = "productname";
* //ddlProduct.DataValueField = "pid";
* //ddlProduct.DataBind();
* //System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Product(s)--", "0");
* //ddlProduct.Items.Insert(0, objListItem);
* }
* }
*
* }
* catch (Exception ex)
* {
* ErrHandler.writeError(ex.Message, ex.StackTrace);
* //return null;
* }
* finally { con.Close(); }
*
* }
*
* protected void btnAdd_Click(object sender, EventArgs e)
* {
* DataTable dtProduct = new DataTable();
* dtProduct = GetProducts();
*
* if (ViewState["Products"] != null)
* {
* dtProduct = (DataTable)ViewState["Products"];
*
*
* Repeater1.DataSource = dtProduct;
* Repeater1.DataBind();
* Repeater1.Visible = true;
* }
* else
* {
* Repeater1.DataSource = null;
* Repeater1.DataBind();
* Repeater1.Visible = false;
* }
*
* // ddlProductName.SelectedItem = string.Empty;
* //ddlCategory.SelectedIndex = 0;
* //ddlProduct.SelectedIndex = 0;
*
* txtquantity.Text = "0";
* }
*
*
*
* private DataTable GetProducts()
* {
*
* DataTable dtProduct = null;
* if (ViewState["SrNo"] != null)
* {
* int SrNo = Convert.ToInt32((ViewState["SrNo"]));
* SrNo++;
* ViewState["SrNo"] = SrNo;
* }
* else
* {
* ViewState["SrNo"] = 1;
* }
*
* if (ViewState["Products"] == null)
* {
*
* // [ProdId],[ProdName],[ProdBrand] ,[ProdSize]
*
* dtProduct = new DataTable("Products");
* dtProduct.Columns.Add(new DataColumn("SrNo", typeof(int)));
* dtProduct.Columns.Add(new DataColumn("CatId", typeof(int)));
* dtProduct.Columns.Add(new DataColumn("CategoryName", typeof(string)));
* dtProduct.Columns.Add(new DataColumn("ProdId", typeof(int)));
* dtProduct.Columns.Add(new DataColumn("ProductName", typeof(string)));
* dtProduct.Columns.Add(new DataColumn("Quantity", typeof(string)));
*
* ViewState["Products"] = dtProduct;
* }
* else
* {
* dtProduct = (DataTable)ViewState["Products"];
* }
* DataRow dtRow = dtProduct.NewRow();
*
* dtRow["SrNo"] = ViewState["SrNo"];
* //dtRow["ProductName"] = ddlProduct.SelectedItem.ToString();
* //dtRow["ProdId"] = ddlProduct.SelectedValue;
* dtRow["CategoryName"] = ddlCategory.SelectedItem.ToString();
* dtRow["CatId"] = ddlCategory.SelectedValue;
* dtRow["Quantity"] = txtquantity.Text.Trim();
* dtProduct.Rows.Add(dtRow);
* ViewState["Products"] = dtProduct;
* return dtProduct;
* }
*
*
*
* protected void Remove_Product(object sender, EventArgs e)
* {
* try
* {
* // con.Open();
*
* //GridViewRow gr = (GridViewRow)(sender as Control).Parent.Parent;
* //int ind = gr.RowIndex;
* //string pid = (gvproduct.Rows[ind].Cells[0].Text);
* int prodid;
* Button button = (sender as Button);
* //Get the command argument
* string commandArgument = button.CommandArgument;
*
*
* prodid = int.Parse(commandArgument);
*
* DataTable dtProduct = new DataTable();
*
* if (ViewState["Products"] == null)
* {
*
* // [ProdId],[ProdName],[ProdBrand] ,[ProdSize]
*
* dtProduct = new DataTable("Products");
* dtProduct.Columns.Add(new DataColumn("SrNo", typeof(int)));
* dtProduct.Columns.Add(new DataColumn("ProductName", typeof(string)));
* dtProduct.Columns.Add(new DataColumn("CategoryName", typeof(string)));
* dtProduct.Columns.Add(new DataColumn("Quantity", typeof(string)));
*
* ViewState["Products"] = dtProduct;
* }
* else
* {
* dtProduct = (DataTable)ViewState["Products"];
* }
*
*
* // dtProduct = (DataTable)ViewState["Products"];
*
* DataRow[] drr = dtProduct.Select("SrNo=' " + prodid + " ' ");
* foreach (var row in drr)
* row.Delete();
*
* // dtProduct.Rows.RemoveAt(prodid);
*
* dtProduct.AcceptChanges();
* Repeater1.DataSource = dtProduct;
* Repeater1.DataBind();
* //ddlProduct.SelectedIndex = 0;
* ddlCategory.SelectedIndex = 0;
* txtquantity.Text = "0";
* //if (Request.QueryString["id"] != null)
* //{
* // Int64 OrderID = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
* // string s = "delete from Ordersystem_orderproducts where oid=" + OrderID + " and pid=" + pid + "";
* // SqlCommand cmd = new SqlCommand(s, con);
* // int t = cmd.ExecuteNonQuery();
*
*
* //}
* //ScriptManager.RegisterStartupScript(this, GetType(), "alertmsg", "alert('Product Remove Successfully');", true);
* //con.Close();
*
* ScriptManager.RegisterStartupScript(this, GetType(), "alertmsg", "alert('Product Removed Successfully');", true);
*
* }
* catch (Exception p)
* { }
* finally
* {
* //con.Close();
* }
* }
*
*/
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0, Result1 = 0, Result2 = 0;
DataTable dtProduct = new DataTable();
//Response.Write(hf1.Value);
//String valuesColor = hfcolorid.Value, valuesSize = hfsizeid.Value;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnstring"].ConnectionString);
//id, worksheetno, employeeid, totalpairs, vshape, silai, factorysecond, isdeleted, createddate
articleproduction objarticleproduction = new articleproduction();
objarticleproduction.worksheetno = Convert.ToInt64(txtworksheetno.Text);
objarticleproduction.employeeid = Convert.ToInt64(hfemployeeid.Value);
if (cbvshape.Checked)
{
objarticleproduction.vshape = Convert.ToInt64(txttotalpairs.Text);
}
else if (cbsilai.Checked)
{
objarticleproduction.silai = Convert.ToInt64(txttotalpairs.Text);
}
else
{
objarticleproduction.totalpairs = Convert.ToInt64(txttotalpairs.Text);
}
objarticleproduction.factorysecond = Convert.ToInt64(txtfactorysecond.Text);
Result = (new Cls_articleproduction_b().Insert(objarticleproduction));
if (Result > 0)
{
//if (ViewState["Products"] != null)
// dtProduct = (DataTable)ViewState["Products"];
//id, pid, sizeid, colorid, quantity
Label id = new Label(); TextBox quantity = new TextBox();
articlestock objPod = new articlestock();
foreach (RepeaterItem item in Repeater1.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
id = (Label)item.FindControl("lblid");
quantity = (TextBox)item.FindControl("txtquantity");
}
objPod.pid = Convert.ToInt64(txtpid.Text);
objPod.sizeid = Convert.ToInt64(id.Text);
objPod.colorid = Convert.ToInt64(txtcolorid.Text);
objPod.quantity = Convert.ToDecimal(quantity.Text);
Result1 = (new Cls_articlestock_b().InsertUpdate(objPod));
//if (Result1 > 0)
// flag = true;
}
articleloosepairs objarticle = new articleloosepairs();
objarticle.pid = Convert.ToInt64(txtpid.Text);
objarticle.sizegroupid = Convert.ToInt64(txtsizegroupid.Text);
objarticle.colorid = Convert.ToInt64(txtcolorid.Text);
objarticle.quantity = Convert.ToDecimal(txtloosepair.Text);
Result2 = (new Cls_articleloosepairs_b().InsertUpdate(objarticle));
Response.Redirect(Page.ResolveUrl("~/manageworksheets.aspx?mode=a"));
}
else
{
}
}