public DataTable getReceiptData(string strReceiptNo)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
if (string.IsNullOrEmpty(strReceiptNo) == true)
{
return(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT LOTNO, RECEIPT_NUM, ITEM_CODE, PROJECT_NUMBER, CAST(TXN_QTY AS VARCHAR(50)) + ' ' + UOM AS TXN_QTY, STATUS, ITEM_DESCRIPTION FROM TBLQC_DETAILS WHERE STATUS = 1").Tables[0]);
}
else
{
return(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT LOTNO, RECEIPT_NUM, ITEM_CODE, PROJECT_NUMBER, CAST(TXN_QTY AS VARCHAR(50)) + ' ' + UOM AS TXN_QTY, STATUS, ITEM_DESCRIPTION FROM TBLQC_DETAILS WHERE STATUS = 1 AND RECEIPT_NUM = '" + strReceiptNo.Trim() + "'").Tables[0]);
}
}
catch (Exception ex)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), "-");
//return "1~" + objSql.getErrorMsg(ex.ToString());
throw ex;
}
finally
{
objSql = null;
}
}
public DataTable UpdateRecevingDL(string strBarcode, string strStatus, string strUserID)
{
SqlDataLayer objSql = new SqlDataLayer();
SqlParameter[] objParameters = new SqlParameter[4];
try
{
objParameters[0] = new SqlParameter("@BARCODE", SqlDbType.VarChar);
objParameters[1] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
objParameters[2] = new SqlParameter("@STATUS", SqlDbType.VarChar);
objParameters[3] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100);
objParameters[0].Value = strBarcode.Trim();
objParameters[1].Value = strUserID.Trim();
objParameters[2].Value = strStatus.Trim();
objParameters[3].Direction = ParameterDirection.Output;
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Barcode receiving successfully.", strUserID);
//return "0~" + BL_Common.DataTableToJSONWithJSONNet(objSql.ExecuteProcedure_Table(SqlDataLayer.strLocal, "sp_ScanningReceiving", objParameters));
return(objSql.ExecuteProcedure_Table(SqlDataLayer.strLocal, "sp_ScanningReceiving", objParameters));
}
catch (Exception ex)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUserID);
//return "1~" + objSql.getErrorMsg(ex.ToString());
throw ex;
}
finally
{
objParameters = null;
objSql = null;
}
}
public string BL_GetMyRights1(string strUserID)
{
SqlDataLayer objSql = new SqlDataLayer();
string strResult = string.Empty;
try
{
strResult = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT UTYPE FROM TBLUSER WHERE UID = '" + strUserID.Trim() + "'");
if (strResult.Trim() != string.Empty)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Fetching user rights successfully", strUserID);
return(strResult.Trim());
}
else
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Fetching user rights failed.", strUserID);
return("1~Do not have device operational rights.");
}
}
catch (Exception ex)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUserID);
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
public string Asset_Calibration(string strBarcode, string strLastCaliDate, string strUsername)
{
SqlDataLayer objSql = new SqlDataLayer();
SqlParameter[] objParameters = new SqlParameter[5];
try
{
objParameters[0] = new SqlParameter("@ASSETCODE", SqlDbType.VarChar);
objParameters[1] = new SqlParameter("@CALDATE", SqlDbType.DateTime);
objParameters[2] = new SqlParameter("@MODE", SqlDbType.VarChar);
objParameters[3] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
objParameters[4] = new SqlParameter("@RESULT", SqlDbType.VarChar, 600);
objParameters[0].Value = strBarcode.Trim();
if (strLastCaliDate == string.Empty)
{
objParameters[1].Value = DateTime.Now;
}
else
{
objParameters[1].Value = Convert.ToDateTime(strLastCaliDate.Trim());
}
if (strLastCaliDate == "")
{
objParameters[2].Value = "GET";
}
else
{
objParameters[2].Value = "SET";
}
objParameters[3].Value = strUsername.Trim();
objParameters[4].Direction = ParameterDirection.Output;
if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ScanningCalibration", objParameters, "@RESULT", "@RESULT") != "")
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Executed Successfully.", strUsername);
return("0~" + objParameters[4].Value.ToString());
}
else
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Execution Failed.", strUsername);
return("1~Invalid assetcode scanned.");
}
}
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 UpdatePicking(string strPackSlip, string strLocation, string strItemCode, string strQty, string strPacket, string strStatus, string strUserID)
{
SqlDataLayer objSql = new SqlDataLayer();
SqlParameter[] objParameters = new SqlParameter[8];
try
{
objParameters[0] = new SqlParameter("@PACKSLIP", SqlDbType.VarChar);
objParameters[1] = new SqlParameter("@PACKBARCODE", SqlDbType.VarChar);
objParameters[2] = new SqlParameter("@ITEMBARCODE", SqlDbType.VarChar);
objParameters[3] = new SqlParameter("@LOCATION", SqlDbType.VarChar);
objParameters[4] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
objParameters[5] = new SqlParameter("@QTY", SqlDbType.Float);
objParameters[6] = new SqlParameter("@STATUS", SqlDbType.Int);
objParameters[7] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100);
objParameters[0].Value = strPackSlip.Trim();
objParameters[1].Value = strPacket.Trim();
objParameters[2].Value = strItemCode.Trim();
objParameters[3].Value = strLocation.Trim();
objParameters[4].Value = strUserID.Trim();
objParameters[5].Value = Convert.ToDouble(strQty);
objParameters[6].Value = Convert.ToInt32(strStatus);
objParameters[7].Direction = ParameterDirection.Output;
if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ScanningPicking", objParameters, "@RESULT", "@RESULT") != "")
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Material picking successfully", strUserID);
return("0~" + objParameters[7].Value.ToString());
}
else
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Material picking failed", strUserID);
return("1~Error in picking.");
}
}
catch (Exception ex)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUserID);
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objParameters = null;
objSql = null;
}
}
public string getPickSlipData(string strPackSlip, string strUserID)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
return("0~" + BL_Common.dataTableToString(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT A.PICK_SLIP_NO, A.WORK_ORDER_NO, A.ITEM_CODE, REPLACE(REPLACE(A.DESCRIPTION, '@', ''), '$', '') AS DESCRIPTION, A.LOCTAOR AS LOCATOR, SUM(Isnull(A.ISSUED_QTY, 0)) AS PICK_QTY, SUM(Isnull(A.PICKED_QTY, 0)) AS PICKED_QTY, A.UOM FROM DBO.TBLPICK_SLIP_INWORD A INNER JOIN DBO.TBLPICK_SLIP_ASSIGN B ON A.PICK_SLIP_NO = B.PICK_SLIP_NO AND A.ST in (1, 2) AND B.ST = 0 AND B.PICKER = '" + strUserID.Trim() + "' AND A.PICK_SLIP_NO = '" + strPackSlip.Trim() + "' and (isnull(A.ISSUED_QTY, 0) - Isnull(A.PICKED_QTY, 0)) > 0 group by A.PICK_SLIP_NO, A.ITEM_CODE, A.WORK_ORDER_NO, A.DESCRIPTION, A.LOCTAOR, A.UOM").Tables[0]));
}
catch (Exception ex)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), "-");
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
public string getPickSlipNo(string strUserID)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
return("0~" + BL_Common.dataTableToString(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT DISTINCT (A.PICK_SLIP_NO) AS PICK_SLIP_NO FROM DBO.TBLPICK_SLIP_INWORD A INNER JOIN DBO.TBLPICK_SLIP_ASSIGN B ON A.PICK_SLIP_NO = B.PICK_SLIP_NO AND A.ST in (1, 2) AND B.ST = 0 AND B.PICKER = '" + strUserID.Trim() + "' and (isnull(A.ISSUED_QTY, 0) - Isnull(A.PICKED_QTY, 0)) > 0").Tables[0]));
}
catch (Exception ex)
{
BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), "-");
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
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;
}
}
