/// <summary>
/// This function will return a list of all the Group saved in the system database
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <returns></returns>
public NSEGroupDTO GetSingleGroupDetails(string i_sConnectionString, int i_sGroupId)
{
PetaPoco.Database db = null;
NSEGroupDTO objGroupobject = new NSEGroupDTO();
try
{
using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
objGroupobject = db.Query <NSEGroupDTO>("exec st_tra_GetGroupDetails @inp_iGroupID",
new
{
inp_iGroupID = i_sGroupId
}).Single <NSEGroupDTO>();
scope.Complete();
}
}
}
catch (Exception exp)
{
throw exp;
}
return(objGroupobject);
}
/// <summary>
/// This method is used to save Group Master entries.
/// <param name="sConnectionString">DB Connection String</param>
/// <param name="m_objGroupDTO">NSEGroupDTO objects</param>
/// <returns>if save then return true else return false</returns>
public IEnumerable <NSEGroupDTO> SaveGroup(string i_sConnectionString, NSEGroupDTO m_objGroupDTO)
{
#region Paramters
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
bool bReturn = false;
PetaPoco.Database db = null;
#endregion Paramters
#region Out Paramter
var nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int);
nReturnValue.Direction = System.Data.ParameterDirection.Output;
nReturnValue.Value = 0;
var nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int);
nSQLErrCode.Direction = System.Data.ParameterDirection.Output;
nSQLErrCode.Value = 0;
var sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.VarChar);
sSQLErrMessage.Direction = System.Data.ParameterDirection.Output;
sSQLErrMessage.Value = "";
#endregion Out Paramter
IEnumerable <NSEGroupDTO> lstGroup = null;
try
{
using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
lstGroup = db.Query <NSEGroupDTO>("exec st_mst_GroupSave @GroupId OUTPUT,@DownloadedDate,@SubmissionDate,@StatusCodeId,@TypeOfDownload,@DownloadStatus,@inp_iLoggedInUserId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
GroupId = m_objGroupDTO.GroupId,
DownloadedDate = DateTime.Now,//m_objGroupDTO.DownloadedDate,
SubmissionDate = m_objGroupDTO.SubmissionDate,
StatusCodeId = 508006,
TypeOfDownload = m_objGroupDTO.TypeOfDownload,
DownloadStatus = false,
inp_iLoggedInUserId = m_objGroupDTO.LoggedInUserId,
out_nReturnValue = 1,
out_nSQLErrCode = 1,
out_sSQLErrMessage = string.Empty
}).ToList();
#region Error Values
if (Convert.ToInt32(nReturnValue.Value) != 0)
{
Exception e = new Exception();
out_nReturnValue = Convert.ToInt32(nReturnValue.Value);
string sReturnValue = sLookupPrefix + out_nReturnValue;
e.Data[0] = sReturnValue;
if (nSQLErrCode.Value != System.DBNull.Value)
{
out_nSQLErrCode = Convert.ToInt32(nSQLErrCode.Value);
e.Data[1] = out_nSQLErrCode;
}
if (sSQLErrMessage.Value != System.DBNull.Value)
{
out_sSQLErrMessage = Convert.ToString(sSQLErrMessage.Value);
e.Data[2] = out_sSQLErrMessage;
}
Exception ex = new Exception(db.LastSQL.ToString(), e);
bReturn = false;
throw ex;
}
else
{
scope.Complete();
bReturn = true;
}
#endregion Error Values
return(lstGroup);
}
}
}
catch (Exception exp)
{
throw exp;
}
}