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