protected void btnSave_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = (DataTable)ViewState["Operator"]; for (int i = 0; i < dt.Rows.Count; i++) { DateTime datetime = DateTime.Parse(Convert.ToString(dt.Rows[i]["Date"])); string formatteddate = datetime.ToString("yyyy-MM-dd"); object result; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@OPR", 1), new SqlParameter("@PlantCode", Convert.ToString(dt.Rows[i]["PlantCode"])), new SqlParameter("@Line", Convert.ToString(dt.Rows[i]["Line"])), new SqlParameter("@Date", formatteddate), new SqlParameter("@ShiftCode", Convert.ToString(dt.Rows[i]["ShiftCode"])), new SqlParameter("@StationCode", Convert.ToString(dt.Rows[i]["StationCode"])), new SqlParameter("@OperatorName", Convert.ToString(dt.Rows[i]["Name"])), new SqlParameter("@Type", Convert.ToString(dt.Rows[i]["Type"])), new SqlParameter("@EDP", Convert.ToString(dt.Rows[i]["EDP"])), new SqlParameter("@CreatedBy", Convert.ToString(Session["username"])) }; result = DBClass.ExecuteScalar_WithParam(param, "DM_SP_ADD_ASSIGNED_OPERATOR_DATA"); } ScriptManager.RegisterStartupScript(this, this.GetType(), "alert3", "alert('Operator data submitted successfully');", true); GrdOperators.DataSource = null; GrdOperators.DataBind(); btnSave.Visible = false; BindAssignedOperator(); }
public void BindOperatorsGrd() { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@OPR", "8"), new SqlParameter("@PlantCode", lblplantcode.Text), new SqlParameter("@Line", lblline.Text), new SqlParameter("@ShiftCode", lblshift.Text), new SqlParameter("@Date", lbldate.Text), }; DataTable Dt = new DataTable(); Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA"); GrdOperators.DataSource = Dt; GrdOperators.DataBind(); } catch (Exception ex) { _logger.Error(string.Concat("BindCompletedGrid::", ex.Message), ex); } }
protected void btnSave_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = (DataTable)ViewState["Operator"]; //object obj; //SqlParameter[] param = new SqlParameter[] // { // new SqlParameter("@OPR", 12), // new SqlParameter("@plant", dt.Rows[0]["PlantCode"]), // new SqlParameter("@user", Session["username"].ToString()) // }; //obj = DBClass.ExecuteNonQuery_WithParam(param, "SP_OperatorMaster"); for (int i = 0; i < dt.Rows.Count; i++) { object result; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@OPR", 4), new SqlParameter("@plant", Convert.ToString(dt.Rows[i]["PlantCode"])), new SqlParameter("@query", Convert.ToString(dt.Rows[i]["OperatorName"])), new SqlParameter("@edp", Convert.ToString(dt.Rows[i]["EDPNumber"])), new SqlParameter("@user", Convert.ToString(Session["username"])), new SqlParameter("@type", Convert.ToString(dt.Rows[i]["Type"])) }; result = DBClass.ExecuteScalar_WithParam(param1, "SP_OperatorMaster"); } ScriptManager.RegisterStartupScript(this, this.GetType(), "alert3", "alert('Operator data submitted successfully');", true); GrdOperators.DataSource = null; GrdOperators.DataBind(); btnSave.Visible = false; GrdOperators.Visible = false; bindgrid(); }
protected void BindExcel(string filepath, string Extension) { //DataTable dtExcel; // DataTable dtFinal; string conStr = ""; string isHDR = "Yes"; try { switch (Extension) { case ".xls": //Excel 97-03 conStr = ConfigurationManager.ConnectionStrings["Excel03"].ConnectionString; break; case ".xlsx": //Excel 07 conStr = ConfigurationManager.ConnectionStrings["Excel07"].ConnectionString; break; } conStr = String.Format(conStr, filepath, isHDR); OleDbConnection connExcel = new OleDbConnection(conStr); OleDbCommand cmdExcel = new OleDbCommand(); OleDbDataAdapter oda = new OleDbDataAdapter(); DataTable dt = new DataTable(); cmdExcel.Connection = connExcel; connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString(); connExcel.Close(); connExcel.Open(); cmdExcel.CommandText = "SELECT * From [" + SheetName + "]"; oda.SelectCommand = cmdExcel; oda.Fill(dt); connExcel.Close(); //////////////// bool flag = false; DataTable newdt = new DataTable(); newdt.Columns.Add("PlantCode", typeof(string)); newdt.Columns.Add("Line", typeof(string)); newdt.Columns.Add("StationCode", typeof(string)); newdt.Columns.Add("EDP", typeof(string)); newdt.Columns.Add("Name", typeof(string)); newdt.Columns.Add("Type", typeof(string)); newdt.Columns.Add("ShiftCode", typeof(string)); newdt.Columns.Add("Date", typeof(string)); newdt.Columns.Add("Status", typeof(string)); foreach (DataRow dr in dt.Rows) { if (dr["PlantCode"].ToString() != null && dr["PlantCode"].ToString() != string.Empty) { if (dr["Line"].ToString() != null && dr["Line"].ToString() != "") { if (dr["StationCode"].ToString() != null && dr["StationCode"].ToString() != "") { if (dr["EDP"].ToString() != null && dr["EDP"].ToString() != "") { if (dr["Name"].ToString() != null && dr["Name"].ToString() != "") { if (dr["Type"].ToString() != null && dr["Type"].ToString() != "") { if (dr["ShiftCode"].ToString() != null && dr["ShiftCode"].ToString() != "") { if (dr["Date"].ToString() != null && dr["Date"].ToString() != "") { flag = true; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Date is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Shift code is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Type is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Name is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('EDP is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('StationCode is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Line is empty!')", true); return; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('PlantCode is empty!')", true); return; } if (flag == true) { DataRow dr1 = newdt.NewRow(); string result; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PlantCode", Convert.ToString(dr["PlantCode"])), new SqlParameter("@Line", Convert.ToString(dr["Line"])), new SqlParameter("@StationCode", Convert.ToString(dr["StationCode"])), new SqlParameter("@edp", Convert.ToString(dr["EDP"])), new SqlParameter("@Date", Convert.ToDateTime(Convert.ToString(dr["Date"])).ToString("yyyy-MM-dd")), new SqlParameter("@ShiftCode", Convert.ToString(dr["ShiftCode"])), new SqlParameter("@OperatorName", Convert.ToString(dr["Name"])), }; result = DBClass.ExecuteScalar_WithParam(param, "SP_OperatorDetails").ToString(); dr1["PlantCode"] = dr["PlantCode"]; dr1["Line"] = dr["Line"]; dr1["StationCode"] = dr["StationCode"]; dr1["EDP"] = dr["EDP"]; dr1["Name"] = dr["Name"]; dr1["Type"] = dr["Type"]; dr1["ShiftCode"] = dr["ShiftCode"]; dr1["Date"] = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd"); dr1["Status"] = result; newdt.Rows.Add(dr1); if (result != "OK") { count++; } if (count == 0) { btnSave.Visible = true; ViewState["Operator"] = dt; } } ////////////////// } GrdOperators.DataSource = newdt; //GrdOperators.DataSource = dt; GrdOperators.DataBind(); //btnSave.Visible = true; //ViewState["Operator"] = dt; // DataTable DTRequest = new DataTable(); // SqlParameter[] param = new SqlParameter[] //{ // new SqlParameter("@CreatedBy",Convert.ToString(Session["main_userCode"]) ), // new SqlParameter("@t",dtExcel) //}; // DTRequest = DBclass.GetDatatable_WithParam(param, "SP_APP_Upload_Validation"); // GrdOperators.DataSource = DTRequest; // GrdOperators.DataBind(); } catch (Exception ex) { _logger.Error(string.Concat("uploadOperatorFile::", ex.Message), ex); if (ex.Message.Contains("Sheet1") == true) { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Sheet1 Not Found !')", true); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('" + ex.Message + "')", true); } btnSave.Visible = false; // pnlMsgUploadIndex.Visible = true; } finally { // dtExcel.Dispose(); } }