/// <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)); }