public DataTable SelectAll(worksheetmaster objworksheetmaster)
{
DataSet ds = new DataSet();
SqlDataAdapter da;
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = "worksheetmaster_SelectAll",
CommandType = CommandType.StoredProcedure,
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 worksheetmaster SelectById(Int64 id)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
worksheetmaster objworksheetmaster = new worksheetmaster();
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = "worksheetmaster_SelectById",
CommandType = CommandType.StoredProcedure,
Connection = ConnectionString
};
cmd.Parameters.AddWithValue("@id", id);
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)
{
//[id],[productid],[sizeid],[colorid],[createdby],[createddate],[isdeleted]
objworksheetmaster.Id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
objworksheetmaster.Productid = Convert.ToInt64(ds.Tables[0].Rows[0]["productid"]);
//objworksheetmaster.Sizeid = Convert.ToInt64(ds.Tables[0].Rows[0]["sizeid"]);
objworksheetmaster.Sizeid = ds.Tables[0].Rows[0]["sizeid"].ToString();
objworksheetmaster.Colorid = ds.Tables[0].Rows[0]["colorid"].ToString();
objworksheetmaster.Createdby = Convert.ToInt64(ds.Tables[0].Rows[0]["createdby"]);
//objworksheetmaster.isdeleted = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isdeleted"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isdeleted"]);
objworksheetmaster.Createddate = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["createddate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["createddate"]);
//objworksheetmaster.orderstatus = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["orderstatus"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["orderstatus"]);
}
}
}
}
}
catch (Exception ex)
{
////ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objworksheetmaster);
}
public Int64 Insert(worksheetmaster objworksheetmaster)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = "worksheetmaster_Insert",
CommandType = CommandType.StoredProcedure,
Connection = ConnectionString
};
SqlParameter param = new SqlParameter
{
ParameterName = "@id",
Value = 0,
SqlDbType = SqlDbType.BigInt,
Direction = ParameterDirection.InputOutput
};
cmd.Parameters.Add(param);
//[id],[productid],[sizeid],[colorid],[createdby],[createddate],[isdeleted]
//cmd.Parameters.AddWithValue("@id", objworksheetmaster.Id);
cmd.Parameters.AddWithValue("@productid", objworksheetmaster.Productid);
cmd.Parameters.AddWithValue("@sizeid", objworksheetmaster.Sizeid);
cmd.Parameters.AddWithValue("@colorid", objworksheetmaster.Colorid);
cmd.Parameters.AddWithValue("@createdby", objworksheetmaster.Createdby);
//cmd.Parameters.AddWithValue("@isdeleted", objworksheetmaster.isdeleted);
cmd.Parameters.AddWithValue("@createddate", DateTime.Now);
//cmd.Parameters.AddWithValue("@orderstatus", objworksheetmaster.orderstatus);
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)
{
Int64 Result = 0, Result1 = 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,productid,sizeid,colorid,createdby,createddate,isdeleted
worksheetmaster objworksheetmaster = new worksheetmaster();
objworksheetmaster.Productid = Convert.ToInt64(ddlArticle.SelectedValue.ToString());
//objworksheetmaster.Sizeid = Convert.ToInt64(ddlSize.SelectedValue.ToString());
//objworksheetmaster.Colorid = Convert.ToInt64(ddlColor.SelectedValue.ToString());
objworksheetmaster.Colorid = valuesColor;
objworksheetmaster.Sizeid = valuesSize;
objworksheetmaster.Createdby = Convert.ToInt64(createdby);
objworksheetmaster.Createddate = Convert.ToDateTime(txtWorkDate.Text.ToString());
//PurchaseOrderHeader objcategory = new PurchaseOrderHeader();
//objcategory.PONo = pono;
//objcategory.VendorId = Int64.Parse(ddlVendor.SelectedValue);
//objcategory.isdeleted = false;
if (Request.QueryString["id"] != null)
{
objworksheetmaster.Id = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_worksheetmaster_b().Update(objworksheetmaster));
if (Result > 0)
{
Response.Redirect(Page.ResolveUrl("~/manageworksheets.aspx?mode=u"));
}
else
{
}
}
else
{
Result = (new Cls_worksheetmaster_b().Insert(objworksheetmaster));
if (Result > 0)
{
con.Open();
if (ViewState["Products"] != null)
{
dtProduct = (DataTable)ViewState["Products"];
}
worksheetdetails objPod = new worksheetdetails();
foreach (DataRow row in dtProduct.Rows)
{
//id,worksheetid,particularsid,employeeid,workdate,quantity,remark
objPod.Worksheetid = Result;
objPod.Particularsid = Convert.ToInt64(row["operationid"]);
objPod.Employeeid = Convert.ToInt64(row["employeeid"]);
objPod.Quantity = Convert.ToInt64(row["quantity"]);
objPod.Wages = Convert.ToDouble(row["wages"]);
objPod.Workdate = Convert.ToDateTime(row["date"]);
objPod.Remark = Convert.ToString(row["remark"]);
Result1 = (new Cls_worksheetdetails_b().Insert(objPod));
//if (Result1 > 0)
// flag = true;
}
con.Close();
Response.Redirect(Page.ResolveUrl("~/manageworksheets.aspx?mode=i"));
}
else
{
}
}
}
