/// <summary>
/// This method is used to delete Group details
/// </summary>
/// <param name="sConnectionString">DB COnnection string</param>
/// <param name="m_objNSEGroupDetailsDTO">NSEGroupDetailsDTO object</param>
/// <returns>if delete return true else false</returns>
public bool Delete(string i_sConnectionString, NSEGroupDetailsDTO m_objNSEGroupDetailsDTO)
{
#region Paramters
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
bool bReturn = false;
PetaPoco.Database db = null;
#endregion Paramters
try
{
#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.Size = 9000000;
sSQLErrMessage.Value = "";
#endregion Out Paramter
using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
var res = db.Query <ImplementedCompanyDTO>("exec st_tra_DeleteGroupDetails @i_TransactionMasterId,@inp_iUserId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
i_TransactionMasterId = m_objNSEGroupDetailsDTO.TransactionMasterId,
inp_iUserId = m_objNSEGroupDetailsDTO.LoggedInUserId,
out_nReturnValue = nReturnValue,
out_nSQLErrCode = nSQLErrCode,
out_sSQLErrMessage = sSQLErrMessage
}).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
}
}
}
catch (Exception exp)
{
bReturn = false;
throw exp;
}
return(bReturn);
}
public JsonResult DeleteGroupDetails(string arrIncluded, int acid, int GroupId)
{
bool statusFlag = false;
var ErrorDictionary = new Dictionary <string, string>();
try
{
string[][] arrGroupDetails = null;
Common.Common objCommon = new Common.Common();
if (arrIncluded != "")
{
arrGroupDetails = JsonConvert.DeserializeObject <string[][]>(arrIncluded);
}
DataTable dtDeleteGroupDetails = new DataTable();
dtDeleteGroupDetails.Columns.Add(new DataColumn("TransactionMasterID", typeof(int)));
if (arrGroupDetails != null)
{
for (int i = 0; i < arrGroupDetails.Length; i++)
{
DataRow row = null;
for (int j = 0; j < arrGroupDetails[i].Length; j++)
{
row = dtDeleteGroupDetails.NewRow();
row["TransactionMasterID"] = Convert.ToInt32(arrGroupDetails[i][j]);
dtDeleteGroupDetails.Rows.Add(row);
}
row = null;
}
}
bool bReturn = false;
if (dtDeleteGroupDetails.Rows.Count == 0 || dtDeleteGroupDetails.Rows.Count < 0)
{
ErrorDictionary.Add("error", "Record deletion failed");
}
else if (dtDeleteGroupDetails.Rows.Count > 0)
{
for (int i = 0; i < dtDeleteGroupDetails.Rows.Count; i++)
{
int TransactionMasterId = Convert.ToInt32(dtDeleteGroupDetails.Rows[i]["TransactionMasterID"].ToString());
NSEGroupSL objNSEGroupSL = new NSEGroupSL();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
List <InsiderTradingDAL.NSEGroupDocumentMappingDTO> list = objNSEGroupSL.Get_Singledocument_Details(objLoginUserDetails.CompanyDBConnectionString, TransactionMasterId);
InsiderTradingDAL.NSEGroupDetailsDTO objNSEGroupDetailsDTO = new InsiderTradingDAL.NSEGroupDetailsDTO();
objNSEGroupDetailsDTO.TransactionMasterId = TransactionMasterId;
objNSEGroupDetailsDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID;
bReturn = objNSEGroupSL.Delete_User_From_NSEGroup(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDetailsDTO);
string directory = ConfigurationManager.AppSettings["Document"];
string OutputPathWithFileName = Path.Combine(directory, objLoginUserDetails.CompanyName, ConstEnum.Code.NseDocumentFormC.ToString(), TransactionMasterId.ToString());
foreach (var path in list)
{
string sGUID = Convert.ToString(path.GUID);
string sourceFileNameWithPath = Path.Combine(directory, objLoginUserDetails.CompanyName, ConstEnum.Code.NseDocumentFormC.ToString(), GroupId.ToString(), Convert.ToString(sGUID.ToString()));
FileInfo file = new FileInfo(Path.Combine(directory, objLoginUserDetails.CompanyName, ConstEnum.Code.NseDocumentFormC.ToString(), GroupId.ToString(), Convert.ToString(sGUID.ToString())));
if (file.Exists)
{
System.IO.File.Move(sourceFileNameWithPath, OutputPathWithFileName + "//" + sGUID);
}
}
statusFlag = true;
}
if (bReturn)
{
statusFlag = true;
ErrorDictionary.Add("success", "Record deleted successfully");
}
else
{
ErrorDictionary.Add("error", "Record deletion failed");
}
}
FillGrid(Common.ConstEnum.GridType.NSEDownloadDeleteGroupDetails, "0", null, null);
}
catch (Exception ex)
{
throw ex;
}
return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet));
}
