public static List <MDonorPartner> List() { List <MDonorPartner> lisQuery = new List <MDonorPartner>(); using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString())) { try { SqlCommand cmd = new SqlCommand("sp_DonorPartner_Lis", con); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; con.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MDonorPartner entRow = new MDonorPartner(); entRow.DonorPartnerId = Convert.ToInt32(reader["DonorPartnerId"]); entRow.DonorCode = Convert.ToString(reader["DonorCode"]); entRow.DonorName = Convert.ToString(reader["DonorName"]); lisQuery.Add(entRow); } } con.Close(); } catch (Exception ex) { lisQuery = null; } } return(lisQuery); }
public BaseResponse InsertDonorPartner([FromBody] DonorPartnersRequest 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 (MDonorPartner model in request.DonorPartners) { MDonorPartner DonorPartner = new MDonorPartner(); DonorPartner.DonorCode = model.DonorCode; DonorPartner.DonorName = model.DonorName; DonorPartner.FundingPartner = model.FundingPartner; BDonorPartner.Insert(DonorPartner); } 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(MDonorPartner ent) { using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString())) { SqlCommand cmd = new SqlCommand("sp_DonorPartner_Ins", con); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IDonorCode", SqlDbType.VarChar).Value = ent.DonorCode; cmd.Parameters.Add("@IDonorName", SqlDbType.VarChar).Value = ent.DonorName; cmd.Parameters.Add("@IFundingPartner", SqlDbType.VarChar).Value = ent.FundingPartner; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } return(0); }
public ActionResult Register(LoadFundsViewModel model, HttpPostedFileBase imageFile) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { Session objSession = new Session() { UserId = AutenticationManager.GetUser().IdUsuario, }; List <MDonorPartner> entList = new List <MDonorPartner>(); List <ModelDonorPartnerResult> entListData = new List <ModelDonorPartnerResult>(); entListData = (List <ModelDonorPartnerResult>)Session["ListDonors"]; foreach (ModelDonorPartnerResult item in entListData) { MDonorPartner mDonorPartner = new MDonorPartner(); mDonorPartner.DonorCode = item.DonorCode; mDonorPartner.DonorName = item.DonorName; mDonorPartner.FundingPartner = item.FundingPartner; entList.Add(mDonorPartner); } response = new WebApiDonorPartner().InsertDonorPartner(entList, objSession); string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2"); objResult.message = statusCode.Equals("2") ? statusMessage : string.Format(MessageResource.SaveSuccess, "Donors");; } catch (Exception ex) { objResult.message = string.Format(MessageResource.SaveError + "Error :" + ex.Message, "Donors"); } return(Json(objResult)); }