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