public string BL_AuthenticateLogin(string strUsername, string strPassword) { SqlDataLayer objSql = new SqlDataLayer(); SqlParameter[] objParameters = new SqlParameter[3]; try { objParameters[0] = new SqlParameter("@USERNAME", SqlDbType.VarChar); objParameters[1] = new SqlParameter("@PASSWORD", SqlDbType.VarChar); objParameters[2] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100); objParameters[0].Value = strUsername.Trim(); objParameters[1].Value = strPassword.Trim(); objParameters[2].Direction = ParameterDirection.Output; if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Login", objParameters, "@RESULT", "@RESULT") != "") { BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Login Succesfully", strUsername); return("0~" + objParameters[2].Value.ToString()); } else { BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Login Failed", strUsername); return("1~Invalid login details"); } } catch (Exception ex) { BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUsername); return("1~" + objSql.getErrorMsg(ex.ToString())); } finally { objParameters = null; objSql = null; } }
public string Get_Processes(string strProcessCard, string strUsername) { SqlDataLayer objSql = new SqlDataLayer(); try { if (objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT COUNT(BARCODE) FROM TBLPROCESSCARD WHERE BARCODE = '" + strProcessCard.Trim() + "'") != 0) { return("0~" + BL_Common.dataTableToString(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT DISTINCT PROCESSSTAGE FROM TBLPROCESSCARD_SUBITEM INNER JOIN TBLPROCESS_ASSIGN ON TBLPROCESSCARD_SUBITEM.PROCESSSTAGE = TBLPROCESS_ASSIGN.PROCESS WHERE DBO.FNSPLIT(TBLPROCESS_ASSIGN.OPERATOR, '=', 1) = '" + strUsername.Trim() + "' AND TBLPROCESSCARD_SUBITEM.BARCODE = '" + strProcessCard.Trim() + "' AND TBLPROCESSCARD_SUBITEM.STATUS = 0").Tables[0])); } else { return("1~" + "Process card barcode not exist."); } } catch (Exception ex) { return("1~" + objSql.getErrorMsg(ex.ToString())); } finally { objSql = null; } }
public string GetmyProcessWIP(string strSerial_barcode, string strUsername) { SqlDataLayer objSql = new SqlDataLayer(); DataTable dt_Process = new DataTable(); DataTable dt_Final = new DataTable(); string strProcessCard = ""; try { strProcessCard = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT PROCESSCARD FROM TBLWO_INWARD WHERE TRACKING_ID = '" + strSerial_barcode.Trim() + "'"); if (Convert.ToInt32(objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(COUNT(*) AS VARCHAR(50)) FROM TBLWO_INWARD WHERE PROCESSCARD = '" + strProcessCard.Trim() + "' AND TRACKING_ID = '" + strSerial_barcode.Trim() + "'")) == 0) { throw new Exception("Invalid Process card or serial number scanned."); } dt_Process = objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT DISTINCT PROCESSSTAGE, AUTONUM FROM VW_PRODSTAGES WHERE BARCODE = '" + strProcessCard.Trim() + "' AND STATUS = 0 ORDER BY AUTONUM ASC").Tables[0]; //UID = '" + clsInit.GstrUserID.Trim() + "' AND dt_Process.Columns.Add("Rework", typeof(string)); foreach (DataRow dr in dt_Process.Rows) { string strReworkFlag = string.Empty; strReworkFlag = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(RECNO AS VARCHAR(50)) FROM TBLREWORK WHERE WO_NO = '" + strProcessCard.Split('-').GetValue(0).ToString() + "' AND SER = '" + strSerial_barcode.Trim() + "' AND PROCESS = '" + dr["PROCESSSTAGE"].ToString() + "' and Stage_Ref = " + dr["AUTONUM"] + " AND ST = 0;"); if (strReworkFlag.Trim() == "") { dr["Rework"] = "0"; } else { dr["Rework"] = strReworkFlag;; } } dt_Final.Columns.Add("Ref", typeof(int)); dt_Final.Columns.Add("ProcessStage", typeof(string)); dt_Final.Columns.Add("Rework", typeof(string)); foreach (DataRow dr in dt_Process.Rows) { if (dr["Rework"].ToString() == "0") { if (Convert.ToInt32(objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(COUNT(RECNO) AS VARCHAR(50)) FROM TBLPRODUCTION WHERE BARCODE = '" + strProcessCard.Trim() + "' AND TRACKING_ID = '" + strSerial_barcode.Trim() + "' AND PROCESSDESC = '" + dr["PROCESSSTAGE"].ToString() + "' AND CRUSER = '******' AND ST = 2 and Stage_Ref = " + dr["AUTONUM"] + "")) == 0) { DataRow dr_Final = dt_Final.NewRow(); dr_Final["Ref"] = dr["AUTONUM"]; dr_Final["ProcessStage"] = dr["ProcessStage"]; dr_Final["Rework"] = dr["Rework"]; dt_Final.Rows.Add(dr_Final); dt_Final.AcceptChanges(); } } else { DataRow dr_Final = dt_Final.NewRow(); dr_Final["Ref"] = dr["AUTONUM"]; dr_Final["ProcessStage"] = dr["ProcessStage"]; dr_Final["Rework"] = dr["Rework"]; dt_Final.Rows.Add(dr_Final); dt_Final.AcceptChanges(); } } return("0~" + BL_Common.dataTableToString(dt_Final)); } catch (Exception ex) { return("1~" + objSql.getErrorMsg(ex.ToString())); } finally { objSql = null; } }