protected void btnSave_Click(object sender, EventArgs e) { //id, farmerid, productid, quantity, rate, createddate, isdeleted Int64 Result = 0, Result1 = 0; if (Request.QueryString["id"] != null) { } else { product objproduct = new product(); dispatchdetails objdispatchdetails = new dispatchdetails(); if (Session["userid"] != null) { objdispatchdetails.senderid = Convert.ToInt64(Session["userid"]); } else { Response.Redirect(Page.ResolveUrl("~/default.aspx")); } foreach (RepeaterItem item in Repeater1.Items) { //qtyrequested = int.Parse((item.FindControl("LabelQuantity") as Label).Text); Label pid = (Label)item.FindControl("lblproductid"); //Label rate = (Label)item.FindControl("lblrate"); TextBox quantity = (TextBox)item.FindControl("txtqty"); //objfarmer.farmerid = Convert.ToInt64(hffarmerid.Value); objdispatchdetails.productid = Convert.ToInt64(pid.Text); objdispatchdetails.quantity = Convert.ToInt64(quantity.Text); Result = (new Cls_dispatchdetails_b().Insert(objdispatchdetails)); } if (Result > 0) { Clear(); spnMessgae.Style.Add("color", "green"); spnMessgae.InnerText = "Information Saved Successfully!!!"; } else { Clear(); spnMessgae.Style.Add("color", "red"); spnMessgae.InnerText = "Failed To Save The Information..."; } //Response.Redirect(Page.ResolveUrl("~/managefarmers.aspx?mode=i")); //} } }
public Int64 Insert(dispatchdetails objdispatchdetails) { Int64 result = 0; try { //id, farmerid, productid, quantity, rate, createddate, isdeleted SqlCommand cmd = new SqlCommand(); cmd.CommandText = "dispatchdetails_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@id"; param.Value = objdispatchdetails.id; param.SqlDbType = SqlDbType.BigInt; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("productid", objdispatchdetails.productid); cmd.Parameters.AddWithValue("senderid", objdispatchdetails.senderid); cmd.Parameters.AddWithValue("quantity", objdispatchdetails.quantity); 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); }