コード例 #1
0
 public bool DeleteLookupDetails(DeletedLookupDetailsWithAdminUser deletedLookupDetailsWithAdminUser)
 {
     Logging.LogDebugMessage("Method: DeleteLookupDetails, MethodType: Post, Layer: LookupsController, Parameters:  Parameters:  DeletedLookupDetailsWithAdminUser = " + JsonConvert.SerializeObject(deletedLookupDetailsWithAdminUser));
     using (LookupsBL lookupsBL = new LookupsBL())
     {
         return(lookupsBL.DeleteLookupDetails(deletedLookupDetailsWithAdminUser));
     }
 }
コード例 #2
0
ファイル: LookupsDAL.cs プロジェクト: charan148/NewProject
        /// <summary>Delete LookupDetails</summary>
        /// <param name="deletedLookupDetailsWithAdminUser">The DeletedLookupDetailsWithAdminUser Object.</param>
        /// <returns>returns Lookup Details List.</returns>
        public bool DeleteLookupDetails(DeletedLookupDetailsWithAdminUser deletedLookupDetailsWithAdminUser)
        {
            var dataset  = new DataSet();
            var response = false;

            Logging.LogDebugMessage("Method: DeleteLookupDetails, MethodType: Post, Layer: LookupsDAL, Parameters:  Parameters: DeletedLookupDetailsWithAdminUser = "******"USP_DeleteLookupdetails";
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.Add(new SqlParameter()
                    {
                        ParameterName = "@LookupDetailsIds", Value = deletedLookupDetailsWithAdminUser.LookupDetailsIds
                    });
                    command.Parameters.Add(new SqlParameter()
                    {
                        ParameterName = "@AdminUserID", Value = deletedLookupDetailsWithAdminUser.AdminUserID
                    });

                    using (SqlDataAdapter adapter = new SqlDataAdapter(command))
                    {
                        adapter.Fill(dataset);
                        if (dataset != null)
                        {
                            response = true;
                        }
                    }
                }
            }
            catch (SqlException sqlEx)
            {
                Logging.LogErrorMessage("Method: DeleteLookupDetails, Layer: LookupsDAL, Stack Trace: " + sqlEx.ToString());
                throw;
            }
            catch (Exception ex)
            {
                Logging.LogErrorMessage("Method: DeleteLookupDetails, Layer: LookupsDAL, Stack Trace: " + ex.ToString());
                throw;
            }
            return(response);
        }
コード例 #3
0
ファイル: LookupsBL.cs プロジェクト: charan148/NewProject
 /// <summary>Delete LookupDetails</summary>
 /// <param name="deletedLookupDetailsWithAdminUser">The DeletedLookupDetailsWithAdminUser Object.</param>
 /// <returns>returns Lookup Details List.</returns>
 public bool DeleteLookupDetails(DeletedLookupDetailsWithAdminUser deletedLookupDetailsWithAdminUser)
 {
     Logging.LogDebugMessage("Method: DeleteLookupDetails, MethodType: Post, Layer: LookupsBL, Parameters:  DeletedLookupDetailsWithAdminUser = "******"Method: DeleteLookupDetails, Layer: LookupsBL, Stack Trace: " + sqlEx.ToString());
         throw;
     }
     catch (Exception ex)
     {
         Logging.LogErrorMessage("Method: DeleteLookupDetails, Layer: LookupsBL, Stack Trace: " + ex.ToString());
         throw;
     }
 }