public int Incluir_Mobreq_Main(Mobreq_main Reg)
{
Mobreq_Data obj = new Mobreq_Data(_connection);
int _numero = obj.Incluir_Mobreq_Main(Reg);
return(_numero);
}
public Exception Alterar_Situacao(string Guid, short NovaSituacao, int User)
{
using (GTI_Context db = new GTI_Context(_connection)) {
try {
Mobreq_main b = db.Mobreq_Main.First(i => i.Guid == Guid);
b.Situacao = NovaSituacao;
b.UserId2 = User;
b.Data_Evento2 = DateTime.Now;
db.SaveChanges();
} catch (Exception ex) {
return(ex);
}
return(null);
}
}
public ActionResult Mobreq_sola(MobReqViewModel model)
{
Mobreq_bll mobreqRepository = new Mobreq_bll(_connection);
string _guid = _guid = Guid.NewGuid().ToString("N");
int _userId = Convert.ToInt32(Session["hashid"]);
bool _func = Session["hashfunc"].ToString() == "S" ? true : false;
Mobreq_main reg = new Mobreq_main()
{
Guid = _guid,
Codigo = model.Codigo,
Tipo = model.Evento_Codigo,
Data_Inclusao = DateTime.Now,
Data_Evento = Convert.ToDateTime(model.Data_Evento),
UserId = _userId,
UserPrf = _func,
Obs = model.Obs,
Situacao = 1
};
int _num = mobreqRepository.Incluir_Mobreq_Main(reg);
return(RedirectToAction("Mobreq_menu"));
}
public int Incluir_Mobreq_Main(Mobreq_main Reg)
{
using (var db = new GTI_Context(_connection)) {
db.Database.CommandTimeout = 180;
int _numero = 1;
var Sql = (from p in db.Mobreq_Main where p.Ano == DateTime.Now.Year select p.Numero).FirstOrDefault();
if (Sql > 0)
{
_numero = (from p in db.Mobreq_Main where p.Ano == DateTime.Now.Year select p.Numero).Max() + 1;
}
object[] Parametros = new object[11];
Parametros[0] = new SqlParameter {
ParameterName = "@guid", SqlDbType = SqlDbType.VarChar, SqlValue = Reg.Guid
};
Parametros[1] = new SqlParameter {
ParameterName = "@codigo", SqlDbType = SqlDbType.Int, SqlValue = Reg.Codigo
};
Parametros[2] = new SqlParameter {
ParameterName = "@tipo", SqlDbType = SqlDbType.Int, SqlValue = Reg.Tipo
};
Parametros[3] = new SqlParameter {
ParameterName = "@data_evento", SqlDbType = SqlDbType.SmallDateTime, SqlValue = Reg.Data_Evento
};
Parametros[4] = new SqlParameter {
ParameterName = "@data_inclusao", SqlDbType = SqlDbType.SmallDateTime, SqlValue = Reg.Data_Inclusao
};
if (string.IsNullOrEmpty(Reg.Obs))
{
Parametros[5] = new SqlParameter {
ParameterName = "@obs", SqlValue = DBNull.Value
}
}
;
else
{
Parametros[5] = new SqlParameter {
ParameterName = "@obs", SqlDbType = SqlDbType.VarChar, SqlValue = Reg.Obs
}
};
Parametros[6] = new SqlParameter {
ParameterName = "@userid", SqlDbType = SqlDbType.Int, SqlValue = Reg.UserId
};
Parametros[7] = new SqlParameter {
ParameterName = "@userprf", SqlDbType = SqlDbType.Bit, SqlValue = Reg.UserPrf
};
Parametros[8] = new SqlParameter {
ParameterName = "@situacao", SqlDbType = SqlDbType.Int, SqlValue = Reg.Situacao
};
Parametros[9] = new SqlParameter {
ParameterName = "@numero", SqlDbType = SqlDbType.Int, SqlValue = _numero
};
Parametros[10] = new SqlParameter {
ParameterName = "@ano", SqlDbType = SqlDbType.SmallInt, SqlValue = DateTime.Now.Year
};
try {
db.Database.ExecuteSqlCommand("INSERT INTO mobreq_main(guid,Codigo,Tipo,data_evento,data_inclusao,obs,userid,userprf,situacao,numero,ano) " +
"VALUES(@guid,@Codigo,@Tipo,@data_evento,@data_inclusao,@obs,@userid,@userprf,@situacao,@numero,@ano)", Parametros);
} catch {
return(0);
}
return(_numero);
}
}