public BaseResponse InsertImplementAgency([FromBody] ImplementAgenciesRequest request) { BaseResponse response = new BaseResponse(); using (TransactionScope scope = new TransactionScope()) { try { if (!BAplication.ValidateAplicationToken(request.ApplicationToken)) { response.Code = "2"; response.Message = Messages.ApplicationTokenNoAutorize; return(response); } string webRoot = _env.ContentRootPath; string rootPath = _appSettings.Value.rootPath; string ProjectPath = _appSettings.Value.ProjectPath; BaseRequest baseRequest = new BaseRequest(); foreach (MImplementAgency model in request.ImplementAgencies) { MImplementAgency fund = new MImplementAgency(); fund.ImplementAgencyCode = model.ImplementAgencyCode; fund.Description = model.Description; fund.ShortDescription = model.ShortDescription; BImplementAgency.Insert(fund); } scope.Complete(); response.Code = "0"; response.Message = "Success"; } catch (Exception ex) { response.Code = "2"; response.Message = ex.Message; scope.Dispose(); } } return(response); }
public static int Insert(MImplementAgency ent) { using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString())) { SqlCommand cmd = new SqlCommand("sp_ImplementAgency_Ins", con); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IImplementAgencyCode", SqlDbType.VarChar).Value = ent.ImplementAgencyCode; cmd.Parameters.Add("@IDescription", SqlDbType.VarChar).Value = ent.Description; cmd.Parameters.Add("@IShortDescription", SqlDbType.VarChar).Value = ent.ShortDescription; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } return(0); }
public static List <MImplementAgency> List() { List <MImplementAgency> lisQuery = new List <MImplementAgency>(); using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString())) { try { SqlCommand cmd = new SqlCommand("sp_ImplementAgency_Lis", con); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; con.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MImplementAgency entRow = new MImplementAgency(); entRow.ImplementAgencyId = Convert.ToInt32(reader["ImplementAgencyId"]); entRow.ImplementAgencyCode = Convert.ToString(reader["ImplementAgencyCode"]); entRow.Description = Convert.ToString(reader["Description"]); entRow.ShortDescription = Convert.ToString(reader["ShortDescription"]); lisQuery.Add(entRow); } } con.Close(); } catch (Exception ex) { lisQuery = null; } } return(lisQuery); }
public static int Insert(MImplementAgency ent) { return(DAImplementAgency.Insert(ent)); }