public void tratamentos(string set_trat = "")
{
ViewBag.tratamentos = "";
List <SelectListItem> tratamentos = new List <SelectListItem>();
string item1 = GeralResource.RecRes(181).ToUpper();
string item2 = GeralResource.RecRes(182).ToUpper();
string item3 = GeralResource.RecRes(183).ToUpper();
string item4 = GeralResource.RecRes(184).ToUpper();
tratamentos.Add(new SelectListItem {
Value = ""
});
tratamentos.Add(new SelectListItem {
Value = "1", Text = item1
});
tratamentos.Add(new SelectListItem {
Value = "2", Text = item2
});
tratamentos.Add(new SelectListItem {
Value = "3", Text = item3
});
tratamentos.Add(new SelectListItem {
Value = "4", Text = item4
});
var list = new SelectList(tratamentos, "Value", "Text", set_trat);
ViewBag.tratamentos = list;
}
public void paises(long country_id = 0)
{
exist_countries exist_countries = new exist_countries();
var collection_countries = exist_countries.Consultar(0);
collection_countries.Insert(0, new CountriesDto {
name = GeralResource.RecRes(623), country_id = 0
});
var arrSelectList = new SelectList(collection_countries, "country_id", "name", country_id);
ViewBag.userLog = getUser();
ViewBag.paises = arrSelectList;
}
public ActionResult AlterarSenha(Exist_UsersDto Models)
{ // alterar senha quando o usuario digitou senha temporaria
try
{
exist_users user = new exist_users();
string cSenha = Request.Form["user_password_confirm"];
string truePass = Models.user_password;
Models = user.consultarUsuario(Models.user_id);
Models.user_password = truePass;
Models.user_password_confirm = cSenha;
RemoveReferences(ModelState, "user_country");
if (Models.user_password != Models.user_password_confirm)
{
ModelState.AddModelError("user_password", GeralResource.RecRes(120));
paises();
tratamentos();
string contentView = RenderViewToString("~/Views/Home/FormPass.cshtml", Models);
return(Json(new { status = "validation", view = contentView }));
}
if (CalculateEntropy(Models.user_password) < 2)
{
ModelState.AddModelError("user_password", GeralResource.RecRes(626));
paises();
tratamentos();
string contentView = RenderViewToString("~/Views/Home/FormPass.cshtml", Models);
return(Json(new { status = "validation", view = contentView }));
}
string retorno = user.AlterarSenha(Models);
if (retorno != "1")
{
}
return(Json(new { status = "success", message = GeralResource.RecRes(448) }));
}
catch (Exception ex)
{
return(Json(new { status = "error", message = GeralResource.RecRes(561) }));
}
}
public void SetLanguage(Controller context)
{
try
{
string culture = "";
if (Session["culture"] != null && !Session["culture"].ToString().Equals(""))
{
culture = Session["culture"].ToString();
}
else
{
culture = "en";
}
Session["culture"] = culture;
//context.TempData.Keep("culture");
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(Session["getCulture"].ToString());
Thread.CurrentThread.CurrentUICulture = Thread.CurrentThread.CurrentCulture;
recres rcr = new recres();
string Success = rcr.ConfigLanguage(context.Server.MapPath("~/padv.cfg"), (string)Session["lang_code"]);
if (Success == "OK")
{
context.Session["rcr"] = rcr;
GeralResource.SetGeral();
}
else
{
Console.WriteLine("Tratar erro para falta de instancia ODBC windows");
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable DefaultTableau(long sp_id, long frm_id = 0)
{
// cria tabela com tableau para receber ingredientes usados por ração, da espécie
DataTable dtTableau = new DataTable();
long r;
var retorno = false;
try
{
var usuario = getUser();
//
growth_phasis growth_phasis = new growth_phasis();
formulas_composition formulas_composition = new formulas_composition();
Local_Ingred_User util = new Local_Ingred_User();
DataTable dt_phases = new DataTable();
if (frm_id == 0)
{
dt_phases = growth_phasis.GetPhasesPorEspecieEUsuario(sp_id, usuario.user_id);
if (dt_phases.Rows.Count < 1)
{
growth_phasis.InsertDefaultGP(usuario.user_id);
dt_phases = growth_phasis.GetPhasesPorEspecieEUsuario(sp_id, usuario.user_id);
}
}
else
{
dt_phases = formulas_composition.GetPhasesPorFormula(frm_id, sp_id, usuario.user_id);
if (dt_phases.Rows.Count < 1)
{
growth_phasis.InsertDefaultGP(usuario.user_id);
dt_phases = growth_phasis.GetPhasesPorEspecieEUsuario(sp_id, usuario.user_id);
}
}
try
{
dtTableau.Columns.Add("ingred_id", typeof(string)); // col 0
dtTableau.Columns.Add("line_type", typeof(string)); // col 1
dtTableau.Columns.Add("Ration definition", typeof(string)); // col 2
dtTableau.Columns.Add("price", typeof(string));
foreach (DataRow item in dt_phases.Rows)
{
dtTableau.Columns.Add(item["phasis_mmc"].ToString(), typeof(float));
}
dtTableau.Rows.Add("", "", "");
// replace na unidade usada
var unidd = "kg";
if (usuario.system_id == 2)
{
unidd = "ld";
}
dtTableau.Rows.Add("19", "C", GeralResource.RecRes(12).Replace("{md}", unidd)); // title 'feed budget' 1 line type 'C'
dtTableau.Rows.Add("", "T", GeralResource.RecRes(11)); // title 'ingred inclusion' line type 2
//
exist_ingredients exist_ingredients = new exist_ingredients();
var col_ingredientes = exist_ingredients.ConsultaringredientesParaFeedProgram(0);
var filter_ingreds = col_ingredientes.Where(f => f.ingred_line != "C").OrderBy(f => f.ingred_order).ToList();
// tab exist_ingredientes: line_type 'I' ingrediente; 'O' outros; 'C' consumo
// seleciona só os 'I'ngredientes
// ingreds, inicia na linha 2
// adiciona linhas com ingredientes
foreach (var item in filter_ingreds)
{
var resource = 0;
if (item.resource_id != null)
{
resource = item.resource_id.Value;
}
string name_ingrediente = "";
if (resource == 0)
{
name_ingrediente = item.ingred_mmc;
}
else
{
name_ingrediente = GeralResource.RecRes(resource);
}
if (resource != 115) // foi tirado o Oil/fat por enquanto
{
dtTableau.Rows.Add(item.ingred_id, item.ingred_line, name_ingrediente);
}
}
foreach (DataRow it_rw in dtTableau.Rows)
{
for (int _col = 3; _col < dtTableau.Columns.Count; _col++)
{
var ingred_qtty = it_rw[_col];
if (it_rw["line_type"].ToString() == "C" && ingred_qtty == DBNull.Value)
{ // caso formula nova default 1 para peso
it_rw[_col] = 1;
}
}
}
try
{
//dtTableau.Rows.Add("16", "O", GeralResource.RecRes(115));
dtTableau.Rows.Add("17", "O", GeralResource.RecRes(116));
Session["dt"] = dtTableau;
dtTableau.Dispose();
}
catch (Exception ex)
{
opInt.WRITE_ERR_LOG(ex.Message + "_DefaultTableau3");
throw ex;
}
long ing_id = 0;
dtTableau.AcceptChanges();
foreach (DataRow row in dtTableau.Rows)
{
var local = row["line_type"].ToString();
bool flag = true;
if (local == "L")
{
ing_id = Convert.ToInt64(row["ingred_id"]);
flag = util.VerificarIngUser(usuario.user_id, ing_id);
if (!flag)
{
row.Delete();
}
}
}
dtTableau.AcceptChanges();
return(dtTableau);
}
catch (Exception ex)
{
opInt.WRITE_ERR_LOG(ex.Message + "_DefaultTableau");
throw ex;
}
}
catch (Exception ex)
{
dtTableau.Dispose();
opInt.WRITE_ERR_LOG(ex.Message + "_DefaultTableau1");
throw ex;
}
}
public ActionResult Formulation()
{
try
{
// var usuario = getUser();
//var user_id = usuario.user_id;
//var lang_id = usuario.lang_id;
//var table_id = usuario.table_id;
//var langcode = usuario.lang_id.lang_mmc;
//var langcode = GetLangCode(this);
ViewBag.langcode = Session["lang_code"];
Exist_UsersDto usuario = (Exist_UsersDto)Session["usuario"];
exist_base_tables basetb = new exist_base_tables();
List <Exist_Base_TablesDto> tabelas = basetb.Consultar(usuario.user_id, usuario.lang_id.lang_id);
ViewBag.tabelas = tabelas;
var tabela = tabelas.Where(f => f.table_id == usuario.table_id).ToList()[0];
ViewBag.tabela_ativa_id = usuario.table_id;
ViewBag.tabela_ativa_nome = tabela.table_description;
Measure_Systems MeasSystem = new Measure_Systems();
Measure_SystemsDtoCollection measure_systems = MeasSystem.Consultar();
ViewBag.units = measure_systems;
List <SelectListItem> BaseCalcs = new List <SelectListItem>();
BaseCalcs.Add(new SelectListItem()
{
Text = GeralResource.RecRes(242), Value = "0"
});
BaseCalcs.Add(new SelectListItem()
{
Text = GeralResource.RecRes(243), Value = "1"
});
ViewBag.BaseCalcs = BaseCalcs;
List <SelectListItem> EnUnits = new List <SelectListItem>();
EnUnits.Add(new SelectListItem()
{
Text = GeralResource.RecRes(1112), Value = "1"
});
EnUnits.Add(new SelectListItem()
{
Text = GeralResource.RecRes(1113), Value = "2"
});
ViewBag.EnUnits = EnUnits;
ViewBag.Dose = usuario.dose;
GetConfigEnergia(usuario);
paises();
tratamentos();
ViewBag.usuario = usuario;
ViewBag.specie = usuario.specie_id;
GetSelectionSubProducts();
}
catch (Exception ex)
{
ViewBag.ErrorPage = ex.Message;
}
return(View());
}
