/*
* public DataTable SelectAllAdmin()
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_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 = "farmercollection_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 DataTable farmercollection_WSSelectAll()
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_WSSelectAll";
* 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 bool Delete(Int64 id)
* {
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_Delete";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
*
* cmd.Parameters.AddWithValue("@id", id);
*
* ConnectionString.Open();
* cmd.ExecuteNonQuery();
* }
* catch (Exception ex)
* {
* ErrHandler.writeError(ex.Message, ex.StackTrace);
* return false;
* }
* finally
* {
* ConnectionString.Close();
* }
* return true;
* }
*
* public bool farmercollection_IsActive(Int64 farmercollectionId, Boolean IsActive)
* {
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_IsActive";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
* cmd.Parameters.AddWithValue("@id", farmercollectionId);
* //cmd.Parameters.AddWithValue("@isactive", IsActive);
* ConnectionString.Open();
* cmd.ExecuteNonQuery();
* }
* catch (Exception)
* {
* return false;
* }
* finally
* {
* ConnectionString.Close();
* }
* return true;
* }
*
* public DataTable farmercollection_WSSelectById(Int64 id)
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_WSSelectById";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
* cmd.Parameters.AddWithValue("@id", id);
* 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 Int64 Update(farmercollection objfarmercollection)
* {
* Int64 result = 0;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_Update";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
*
* SqlParameter param = new SqlParameter();
* param.ParameterName = "@id";
* param.Value = objfarmercollection.id;
* param.SqlDbType = SqlDbType.BigInt;
* param.Direction = ParameterDirection.InputOutput;
* cmd.Parameters.Add(param);
* cmd.Parameters.AddWithValue("farmerid", objfarmercollection.farmerid);
* cmd.Parameters.AddWithValue("productid", objfarmercollection.productid);
* cmd.Parameters.AddWithValue("rate", objfarmercollection.rate);
*
* 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;
* }
*
* public DataTable SelectByFarmerId(Int64 id)
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand();
* cmd.CommandText = "farmercollection_SelectByFarmerId";
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Connection = ConnectionString;
*
* SqlParameter param = new SqlParameter();
* param.ParameterName = "@id";
* param.Value = id;
* param.SqlDbType = SqlDbType.BigInt;
* param.Direction = ParameterDirection.Input;
* cmd.Parameters.Add(param);
*
* 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 Int64 Insert(farmercollection objfarmercollection)
{
Int64 result = 0;
try
{
//id, farmerid, productid, quantity, rate, createddate, isdeleted
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "farmercollection_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objfarmercollection.id;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("farmerid", objfarmercollection.farmerid);
cmd.Parameters.AddWithValue("productid", objfarmercollection.productid);
cmd.Parameters.AddWithValue("quantity", objfarmercollection.quantity);
cmd.Parameters.AddWithValue("rate", objfarmercollection.rate);
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)
{
//id, farmerid, productid, quantity, rate, createddate, isdeleted
Int64 Result = 0;
if (Request.QueryString["id"] != null)
{
/*
* objfarmer.id = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
* Result = (new Cls_farmermaster_b().Update(objfarmer));
* if (Result > 0)
* {
* con.Open();
* if (ViewState["Products"] != null)
* dtProduct = (DataTable)ViewState["Products"];
* farmerrates objrates = new farmerrates();
* foreach (DataRow row in dtProduct.Rows)
* {
* //id,worksheetid,particularsid,employeeid,workdate,quantity,remark
* objrates.id = Convert.ToInt64(row["id"]);
* objrates.farmerid = objfarmer.id;
* objrates.productid = Convert.ToInt64(row["productid"]);
* objrates.rate = Convert.ToInt64(row["rate"]);
*
* Result1 = (new Cls_farmerrates_b().Update(objrates));
*
* //if (Result1 > 0)
* // flag = true;
*
*
* }
*
* con.Close();
*
* Response.Redirect(Page.ResolveUrl("~/managefarmers.aspx?mode=u"));
* }
* else
* {
* Clear();
* spnMessgae.Style.Add("color", "red");
* spnMessgae.InnerText = "Farmer Updation Failed...";
* BindFarmer(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
* }
*
*/
}
else
{
//Result = (new Cls_farmermaster_b().Insert(objfarmer));
//if (Result > 0)
//{
farmercollection objfarmer = new farmercollection();
/*
* if (ViewState["Products"] != null)
* dtproductrates = (DataTable)ViewState["Products"];
*
* foreach (DataRow row in dtproductrates.Rows)
* {
* //id,worksheetid,particularsid,employeeid,workdate,quantity,remark
*
* objfarmer.farmerid = Convert.ToInt64( hffarmerid.Value);
* objfarmer.productid = Convert.ToInt64(row["productid"]);
* objfarmer.rate = Convert.ToInt64(row["rate"]);
* objfarmer.quantity = Convert.ToDecimal(row["quantity"]);
* Result = (new Cls_farmercollection_b().Insert(objfarmer));
*
* //if (Result1 > 0)
* // flag = true;
*
* 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...";
*
*
* }
* }
*/
foreach (RepeaterItem item in Repeater1.Items)
{
//qtyrequested = int.Parse((item.FindControl("LabelQuantity") as Label).Text);
Label id = (Label)item.FindControl("lblproductid");
Label rate = (Label)item.FindControl("lblrate");
TextBox quantity = (TextBox)item.FindControl("txtqty");
/*
* objfarmer.farmerid = Convert.ToInt64(hffarmerid.Value);
* objfarmer.productid = Convert.ToInt64((item.FindControl("lblproductid") as Label).Text);
* objfarmer.rate = Convert.ToDecimal((item.FindControl("lblrate") as Label).Text);
* objfarmer.quantity = Convert.ToDecimal((item.FindControl("txtqty") as TextBox).Text);
*
*
*
*/
objfarmer.farmerid = Convert.ToInt64(hffarmerid.Value);
objfarmer.productid = Convert.ToInt64(id.Text);
objfarmer.rate = Convert.ToDecimal(rate.Text);
objfarmer.quantity = Convert.ToDecimal(quantity.Text);
Result = (new Cls_farmercollection_b().Insert(objfarmer));
}
Clear();
spnMessgae.Style.Add("color", "green");
spnMessgae.InnerText = "Information Saved Successfully!!!";
/*
* 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"));
//}
}
}
