internal string Save_DocUpload(string sDocType, byte[] DocImgThumb, string Param1, string Param2,
string Param3, string Param4, string Param5, string sUserCode, string sFileName)
{
IDBManager dbManager = CommonConnection.Connectionstring();
try
{
string sReqNo = string.Empty;
DataSet ds = new DataSet();
dbManager.Open();
dbManager.CreateParameters(10);
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
dbManager.AddParameters(0, "@DocType", sDocType, ParameterDirection.Input);
if (DocImgThumb != null)
{
dbManager.AddParameters(1, "@DocImg", DocImgThumb, ParameterDirection.Input);
}
else
{
dbManager.AddParameters(1, "@DocImg", DBNull.Value, ParameterDirection.Input);
}
dbManager.AddParameters(2, "@UserCode", sUserCode, ParameterDirection.Input);
dbManager.AddParameters(3, "@FileName", sFileName, ParameterDirection.Input);
dbManager.AddParameters(4, "@Param1", Param1, ParameterDirection.Input);
dbManager.AddParameters(5, "@Param2", Param2, ParameterDirection.Input);
dbManager.AddParameters(6, "@Param3", Param3, ParameterDirection.Input);
dbManager.AddParameters(7, "@Param4", Param4, ParameterDirection.Input);
dbManager.AddParameters(8, "@Param5", Param5, ParameterDirection.Input);
dbManager.AddParameters(9, "@ReqNo", string.Empty, ParameterDirection.Output, 50);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "DataImport.GTK_Upld");
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "DataImport.GTK_Upld");
}
else
{
}
sReqNo = dbManager.Parameters[9].Value.ToString();
return(sReqNo);
}
catch (Exception ex)
{
throw ex;
//return null;
}
finally
{
dbManager.Dispose();
}
}
internal DataSet GetFilterConditions()
{
IDBManager dbManager = CommonConnection.Connectionstring();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
DataSet dsFilterCond = new DataSet();
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
if (SessionObjects.obj.GlobalPropertiesObject.FteCode != null && SessionObjects.obj.GlobalPropertiesObject.FteCode != "")
{
dbManager.AddParameters(0, "@FTECODE", SessionObjects.obj.GlobalPropertiesObject.FteCode, ParameterDirection.Input, 10);
}
else
{
dbManager.AddParameters(0, "@FTECODE", DBNull.Value, ParameterDirection.Input, 10);
}
if (SessionObjects.obj.GlobalPropertiesObject.UserCode != null && SessionObjects.obj.GlobalPropertiesObject.UserCode != "")
{
dbManager.AddParameters(1, "@UserCode", SessionObjects.obj.GlobalPropertiesObject.UserCode, ParameterDirection.Input, 100);
}
else
{
dbManager.AddParameters(1, "@UserCode", DBNull.Value, ParameterDirection.Input, 100);
}
dsFilterCond = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "GetFilterConditions");
}
return(dsFilterCond);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}