public string CreateMessageHistory(Conn ObjConn, SqlCommand ObjSqlCommmand, int MessageID, string InquiryID, int FromUserID, string ExecutiveIP, int ToUserID,int MessageSequence, Int16 MessageRead) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "INSERT INTO [MessageHistory]([MessageID],[ExecutiveIP],[CustomerID],[MessageSequence],[MessageRead])" + " VALUES (" + MessageID.ToString() + ",'" + InquiryID + "'," + FromUserID.ToString() + ",'" + ExecutiveIP + "'," + MessageSequence.ToString() + "','" + MessageRead.ToString() + ")" + " Select @@IDENTITY"); }
void Data_Bind() { string sql="select top 1 * from onlinepay where onlinepay_type='alipay'"; Conn Myconn=new Conn(); OleDbConnection conn=new OleDbConnection(Myconn.Constr()); conn.Open(); OleDbCommand Comm=new OleDbCommand(sql,conn); OleDbDataReader dr=Comm.ExecuteReader(); if(dr.Read()) { T_total_fee.Attributes.Add("onkeyup","if(isNaN(value))execCommand('undo')"); T_partner.Text=dr["onlinepay_partnerid"].ToString(); T_seller_email.Text=dr["onlinepay_mid"].ToString(); T_key.Text=dr["onlinepay_key"].ToString(); T_return_url.Text="http://"+Request.ServerVariables["SERVER_NAME"]+"/member/onlinepay/alipay/Alipay_Return.aspx"; T_notify_url.Text="http://"+Request.ServerVariables["SERVER_NAME"]+"/member/onlinepay/alipay/Alipay_Notify.aspx"; if(T_show_url.Text=="") { T_show_url.Text=Request.ServerVariables["SERVER_NAME"]; } Button1.Attributes.Add("onclick","return C_Tb()"); } else { Response.End(); } conn.Close(); }
/// <summary> /// Insert Group Settings /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <param name="ExpiryTime">ExpiryTime</param> /// <param name="RoutingType">RoutingType</param> /// <param name="RoutingTime">RoutingTime</param> /// <param name="LastModifiedBy">LastModifiedBy</param> /// <returns></returns> public string InsertGroupSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID, int ExpiryTime, string RoutingType, int RoutingTime, string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, " INSERT INTO [GroupSettings]([GroupID],[ExpiryTime],[RoutingType],[RoutingTime],[Created],[LastModifiedBy])" + " VALUES (" + GroupID + "," + ExpiryTime + ",'" + RoutingType + "'," + RoutingTime + ",GETDATE(),'" + LastModifiedBy + "')" + " Select @@IDENTITY"); }
/// <summary> /// Is User Group Exists /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <param name="UserID">UserID</param> /// <returns></returns> public bool IsUserGroupExists(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID, int UserID) { int i = ObjConn.executeselectcountquery(ObjSqlCommmand, "select count(1) from [GroupsToUsers] where [GroupID] = " + GroupID.ToString() + " and [UserID] = " + UserID.ToString()); if (i > 0) return true; else return false; }
void Page_Load(Object sender,EventArgs e) { //公共部分============================================== Member_Valicate MCheck=new Member_Valicate(); MCheck.Member_Check("cn"); Conn Myconn=new Conn(); Constr=Myconn.Constr();//获取连接字符串 //公共部分============================================== Data_Bind(); }
static void ConnectInternal(Conn c, Node node, Func<IConnection> create, bool isOutBound) { try { if (c == null) return; // User disposed connection so stop trying. c.Connection = node.Connect(create(), isOutBound); } catch { TaskEx.Delay(1000 * 60 * 5).ContinueWith(n => ConnectInternal(c, node, create, isOutBound)); } }
public static IDisposable Connect(Node node, Func<IConnection> create,bool isOutBound) { var c = new Conn(); var dispose = Disposable.New(() => { if (c.Connection != null) c.Connection.Dispose(); c = null; }); ConnectInternal(c, node, create, isOutBound); return dispose; }
/// <summary> /// Create User /// </summary> /// <param name="ObjConn"></param> /// <param name="ObjSqlCommmand"></param> /// <param name="Login"></param> /// <param name="Password"></param> /// <param name="Status"></param> /// <param name="OnlineStatus"></param> /// <param name="RoleID"></param> /// <param name="Email"></param> /// <param name="Name"></param> /// <param name="Address"></param> /// <param name="Photo"></param> /// <param name="SessionID"></param> /// <param name="LastModifiedBy"></param> /// <returns></returns> public string CreateUser(Conn ObjConn,SqlCommand ObjSqlCommmand, string Login, string Password, string Status, string OnlineStatus, int RoleID, string Email,string Name, string Address,string Photo,string SessionID,string LastModifiedBy) { try { } catch (SqlException ex) { } return ObjConn.executescalarstringquery(ObjSqlCommmand, " INSERT INTO [User]([Login],[Password],[Status],[OnlineStatus],[RoleID],[Email],[Name],[Address],[Photo],[SessionID],[Created],[LastModifiedBy])" +" VALUES ('" + Login + "','" + Password +"','" + Status + "','" + OnlineStatus + "'," +RoleID+ ",'" + Email + "','" + Name + "','" + Address + "','" + Photo + "','" + SessionID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + LastModifiedBy + "')" + " Select @@IDENTITY"); }
public DataTable SelectMessageHistory(Conn ObjConn, SqlCommand ObjSqlCommmand, int MessageID) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "SELECT * from [Message] where [MessageID] = " + MessageID.ToString()); }
public void SingleChar([Values(true, false)] bool prepareCommand) { using (var cmd = Conn.CreateCommand()) { var testArr = new byte[] { prepareCommand ? (byte)200 : (byte)'}', prepareCommand ? (byte)0 : (byte)'"', 3 }; var testArr2 = new char[] { prepareCommand ? (char)200 : '}', prepareCommand ? (char)0 : '"', (char)3 }; cmd.CommandText = "Select 'a'::\"char\", (-3)::\"char\", :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8"; cmd.Parameters.Add(new NpgsqlParameter("p1", NpgsqlDbType.SingleChar) { Value = 'b' }); cmd.Parameters.Add(new NpgsqlParameter("p2", NpgsqlDbType.SingleChar) { Value = 66 }); cmd.Parameters.Add(new NpgsqlParameter("p3", NpgsqlDbType.SingleChar) { Value = "" }); cmd.Parameters.Add(new NpgsqlParameter("p4", NpgsqlDbType.SingleChar) { Value = "\0" }); cmd.Parameters.Add(new NpgsqlParameter("p5", NpgsqlDbType.SingleChar) { Value = "a" }); cmd.Parameters.Add(new NpgsqlParameter("p6", NpgsqlDbType.SingleChar) { Value = (byte)231 }); cmd.Parameters.Add(new NpgsqlParameter("p7", NpgsqlDbType.SingleChar | NpgsqlDbType.Array) { Value = testArr }); cmd.Parameters.Add(new NpgsqlParameter("p8", NpgsqlDbType.SingleChar | NpgsqlDbType.Array) { Value = testArr2 }); if (prepareCommand) { cmd.Prepare(); } using (var reader = cmd.ExecuteReader()) { reader.Read(); var expected = new char[] { 'a', (char)(256 - 3), 'b', (char)66, '\0', '\0', 'a', (char)231 }; for (int i = 0; i < expected.Length; i++) { Assert.AreEqual(expected[i], reader.GetChar(i)); } var arr = (char[])reader.GetValue(8); var arr2 = (char[])reader.GetValue(9); Assert.AreEqual(testArr.Length, arr.Length); for (int i = 0; i < arr.Length; i++) { Assert.AreEqual(testArr[i], arr[i]); Assert.AreEqual(testArr2[i], arr2[i]); } } } }
/// <summary> /// Select Reply based on GroupID and UserID /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <param name="UserID">UserID</param> /// <returns></returns> public DataTable SelectReply(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID, int UserID) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "SELECT * from [Reply] where [GroupID] = " + GroupID.ToString() + " and [UserID] = " + UserID.ToString()); }
/// <summary> /// Delete Gorup Settings /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <returns></returns> public string DeleteGorupSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "Delete from [GroupSettings] output deleted.GroupID where [GroupID] = " + GroupID); }
/// <summary> /// Select all Group /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <returns></returns> public DataTable SelectGroup(Conn ObjConn, SqlCommand ObjSqlCommmand) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "SELECT * from [Group]"); }
/// <summary> /// Inserta, Actualiza o borra de la base de datos seg�n el estado del objeto. /// </summary> public void Save() { try { using (GetData gd = Conn.GetConn("sql")) { switch (this._objStat) { case Stat.New: gd.SentenciaSQL = "INSERT INTO Eventos(IdEvento,Nombre,Direccion,CantPersonas,Categoria,Costo,Status,FechaRegistro,FechaEvento) " + "VALUES(@IdEvento,@Nombre,@Direccion,@CantPersonas,@Categoria,@Costo,@Status,getdate(),@FechaEvento); "; gd.AddParameter(_idevento, "IdEvento"); gd.AddParameter(_nombre, "Nombre"); gd.AddParameter(_direccion, "Direccion"); gd.AddParameter(_cantpersonas, "CantPersonas"); gd.AddParameter(_categoria, "Categoria"); gd.AddParameter(_costo, "Costo"); gd.AddParameter(_status, "Status"); gd.AddParameter(_fechaevento, "FechaEvento"); if (gd.SaveData() > 0) { this._objStat = Stat.Saved; } break; case Stat.Changed: gd.SentenciaSQL = "UPDATE Eventos SET " + "Nombre=@Nombre, " + "Direccion=@Direccion, " + "CantPersonas=@CantPersonas, " + "Categoria=@Categoria, " + "Costo=@Costo, " + "Status=@Status, " + "FechaEvento=FechaEvento() " + "WHERE IdEvento=@IdEvento"; gd.AddParameter(_idevento, "IdEvento"); gd.AddParameter(_nombre, "Nombre"); gd.AddParameter(_direccion, "Direccion"); gd.AddParameter(_cantpersonas, "CantPersonas"); gd.AddParameter(_categoria, "Categoria"); gd.AddParameter(_costo, "Costo"); gd.AddParameter(_status, "Status"); gd.AddParameter(_fechaevento, "FechaEvento"); if (gd.SaveData() > 0) { this._objStat = Stat.Saved; } break; case Stat.Deleted: gd.SentenciaSQL = "DELETE FROM Eventos WHERE IdEvento=@IdEvento"; gd.AddParameter(_idevento, "IdEvento"); if (gd.SaveData() > 0) { this._objStat = Stat.Saved; } break; } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void NestedTransaction() { Conn.BeginTransaction(); Assert.That(() => Conn.BeginTransaction(), Throws.TypeOf <NotSupportedException>()); }
public static string AgregarBitacora(int IdReporte, string BitacoraDescripcion, bool EnviaCorreoIntegrante, bool EnviaCorreoProveedor) { CObjeto Respuesta = new CObjeto(); CUnit.Firmado(delegate(CDB Conn) { string Error = ""; CSecurity permiso = new CSecurity(); if (permiso.tienePermiso("puedeAgregarBitacoraReporteMantenimiento")) { if (Conn.Conectado) { int IdUsuarioSesion = CUsuario.ObtieneUsuarioSesion(Conn); CObjeto Datos = new CObjeto(); CBitacora cBitacora = new CBitacora(); cBitacora.IdReporte = IdReporte; cBitacora.Bitacora = BitacoraDescripcion; cBitacora.IdUsuarioAlta = IdUsuarioSesion; cBitacora.Fecha = DateTime.Now; Error = ValidarAgregarBitacora(cBitacora); if (Error == "") { //cBitacora.Agregar(Conn); //EnviarCorreo if (EnviaCorreoProveedor == true || EnviaCorreoIntegrante == true) { string To = ""; string Cc = ""; string Bcc = ""; string id = ""; string folio = ""; string fechalevantamiento = ""; string pais = ""; string estado = ""; string municipio = ""; string sucursal = ""; string medidor = ""; string tablero = ""; string circuito = ""; string descripcionCircuito = ""; string tipoConsumo = ""; string responsable = ""; string lugar = ""; string correoproveedor = ""; string correoresponsable = ""; string correos = ""; string spReporte = "EXEC sp_Reporte_Consultar @Opcion"; Conn.DefinirQuery(spReporte); Conn.AgregarParametros("@Opcion", 1); CObjeto oMeta = Conn.ObtenerRegistro(); id = oMeta.Get("IdReporte").ToString(); folio = oMeta.Get("Folio").ToString(); fechalevantamiento = oMeta.Get("FechaLevantamiento").ToString(); pais = oMeta.Get("Pais").ToString(); estado = oMeta.Get("Estado").ToString(); municipio = oMeta.Get("Municipio").ToString(); sucursal = oMeta.Get("Sucursal").ToString(); medidor = oMeta.Get("Medidor").ToString(); tablero = oMeta.Get("Tablero").ToString(); circuito = oMeta.Get("Circuito").ToString(); descripcionCircuito = oMeta.Get("DescripcionCircuito").ToString(); tipoConsumo = oMeta.Get("TipoConsumo").ToString(); responsable = oMeta.Get("Responsable").ToString(); correoproveedor = oMeta.Get("CorreoProveedor").ToString(); correoresponsable = oMeta.Get("CorreoResponsable").ToString(); string spCorreos = "EXEC sp_Usuario_ConsultarCorreos @Opcion, @IdReporte"; Conn.DefinirQuery(spCorreos); Conn.AgregarParametros("@Opcion", 1); Conn.AgregarParametros("@IdReporte", IdReporte); SqlDataReader Obten = Conn.Ejecutar(); if (Obten.HasRows) { while (Obten.Read()) { correos = correos + Obten["Correo"].ToString() + ";"; } } Obten.Close(); if (correos != "") { correos = correos.Substring(0, correos.Length - 1); } if (EnviaCorreoProveedor == true && EnviaCorreoIntegrante == true) { To = correoproveedor; Cc = correos; } else { if (EnviaCorreoProveedor == true && EnviaCorreoIntegrante == false) { To = correoproveedor; Cc = correoresponsable; } else { if (EnviaCorreoProveedor == false && EnviaCorreoIntegrante == true) { To = correos; } } } Bcc = ""; lugar = municipio + ' ' + estado + ' ' + pais; string html = ""; string thisEnter = "\r\n"; string separador = HttpContext.Current.Request.UrlReferrer.ToString(); string pagina = separador.Substring(0, separador.LastIndexOf("/") + 1); string URLCorreo = pagina; html = html + thisEnter + "<html>"; html = html + thisEnter + "<head></head>"; html = html + thisEnter + "<body>"; html = html + thisEnter + "<table>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td style='text-align: center; background-color: #f5f5f5;' colspan='4'><strong>Detalle</strong></td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td><strong>Fecha levantamiento</strong></td>"; html = html + thisEnter + "<td>" + fechalevantamiento + "</td>"; html = html + thisEnter + "<td><strong>Responsable</strong></td>"; html = html + thisEnter + "<td>" + responsable + "</td>"; html = html + thisEnter + " </tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td><strong>Lugar</strong></td>"; html = html + thisEnter + "<td>" + lugar + "</td>"; html = html + thisEnter + "<td><strong>Sucursal</strong></td>"; html = html + thisEnter + "<td>" + sucursal + "</td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td><strong>Medidor</strong></td>"; html = html + thisEnter + "<td>" + medidor + "</td>"; html = html + thisEnter + "<td><strong>Tablero</strong></td>"; html = html + thisEnter + "<td>" + tablero + "</td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td><strong>Circuito</strong></td>"; html = html + thisEnter + "<td>" + circuito + "</td>"; html = html + thisEnter + "<td><strong>Descripcion</strong></td>"; html = html + thisEnter + "<td>" + descripcionCircuito + "</td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td><strong>Tipo Consumo</strong></td>"; html = html + thisEnter + "<td>" + tipoConsumo + "</td>"; html = html + thisEnter + "<td><strong>Consumo por día</strong></td>"; html = html + thisEnter + "<td></td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td style='text-align: center; background-color: #f5f5f5;' colspan='4'><strong>Comentario</strong></td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "<tr>"; html = html + thisEnter + "<td colspan='4'>" + BitacoraDescripcion + "</td>"; html = html + thisEnter + "</tr>"; html = html + thisEnter + "</table>"; html = html + thisEnter + "<br/><br/>Favor de iniciar sesión para dar seguimiento <a name='aceptar' href='" + URLCorreo + "' class='enlaceboton' style='text-decoration: none' title=' Ir a sitio web '>Visitar sitio</a> "; html = html + thisEnter + "</body>"; html = html + thisEnter + "</html>"; CMail.EnviarCorreo("*****@*****.**", To, Cc, Bcc, "Asunto", html); } } Respuesta.Add("Datos", Datos); } else { Error = Error + "<li>" + Conn.Mensaje + "</li>"; } } else { Error = Error + "<li>No tienes los permisos necesarios</li>"; } Respuesta.Add("Error", Error); }); return(Respuesta.ToString()); }
public async Task WhereObjQueryOptionTest() { var xx1 = ""; // where object var res1 = await Conn.OpenDebug() .Selecter <Agent>() .Where(new { Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"), Name = "樊士芹", xxx = "xxx" }) .QueryListAsync(); var tuple1 = (XDebug.SQL, XDebug.Parameters); var xx2 = ""; var option = new AgentQueryOption(); option.Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"); option.Name = "樊士芹"; // where method var res2 = await Conn.OpenDebug() .Selecter <Agent>() .Where(option.GetCondition()) .QueryPagingListAsync(option); var tuple2 = (XDebug.SQL, XDebug.Parameters); var xx3 = ""; option.OrderBys = new List <OrderBy> { new OrderBy { Field = "Name", Desc = true } }; // where method -- option orderby var res3 = await Conn.OpenDebug() .Selecter <Agent>() .Where(option.GetCondition()) .QueryPagingListAsync <AgentVM>(option); var tuple3 = (XDebug.SQL, XDebug.Parameters); var xx4 = ""; // where object --> no where var res4 = await Conn.OpenDebug() .Selecter <Agent>() .Where(new { //Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"), //Name = "樊士芹", xxx = "xxx" }) .QueryListAsync(); var tuple4 = (XDebug.SQL, XDebug.Parameters); // no where --> and or var res41 = await Conn.OpenDebug() .Selecter <Agent>() .Where(new { //Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"), //Name = "樊士芹", xxx = "xxx" }) .And(it => it.Id == Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b")) .Or(it => it.AgentLevel == AgentLevel.DistiAgent) .QueryListAsync(); var tuple41 = (XDebug.SQL, XDebug.Parameters); // no where --> or and var res42 = await Conn.OpenDebug() .Selecter <Agent>() .Where(new { //Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"), //Name = "樊士芹", xxx = "xxx" }) .Or(it => it.AgentLevel == AgentLevel.Customer) .And(it => it.Name == "金月琴") .QueryListAsync(); var tuple42 = (XDebug.SQL, XDebug.Parameters); var xx5 = ""; var option2 = new ProductQueryOption { VipProduct = null // true fals null }; // where method -- option orderby var res5 = await Conn.OpenDebug() .Selecter <Product>() .Where(option2.GetCondition()) .QueryPagingListAsync(option2); var tuple5 = (XDebug.SQL, XDebug.Parameters); var xx = ""; }
public static string GenerarReporteMantenimientos() { string Redaccion = ""; CObjeto Respuesta = new CObjeto(); CUnit.Anonimo(delegate(CDB Conn) { string Error = Conn.Mensaje; if (Conn.Conectado) { CObjeto Datos = new CObjeto(); CDB ConexionBaseDatos = new CDB(); SqlConnection con = ConexionBaseDatos.conStr(); //SqlCommand Stored = new SqlCommand("spr_Reporte_MedicionXDía_Mike", con); //Stored.CommandType = CommandType.StoredProcedure; //SqlDataAdapter dataAdapterRegistros = new SqlDataAdapter(Stored); //DataSet ds = new DataSet(); //dataAdapterRegistros.Fill(ds); string spCorreos = "EXEC spr_Reporte_MedicionXDía_Mike"; Conn.DefinirQuery(spCorreos); SqlDataReader Obten = Conn.Ejecutar(); if (Obten.HasRows) { while (Obten.Read()) { Redaccion = "El circuito " + Obten["Circuito"].ToString() + " del medidor " + Obten["Medidor"].ToString() + " del tablero " + Obten["Tablero"].ToString() + " en la sucursal " + Obten["Sucursal"].ToString() + " ha excedido la meta estimada. Meta KwH: " + Obten["MetaKwH"].ToString() + ". Consumo real KwH: " + Obten["RealKwH"].ToString(); string thisEnter = "\r\n"; string emailQuoteBody = ""; emailQuoteBody = emailQuoteBody + thisEnter + "<html>"; emailQuoteBody = emailQuoteBody + thisEnter + "<head>"; emailQuoteBody = emailQuoteBody + thisEnter + "<style>"; emailQuoteBody = emailQuoteBody + thisEnter + "</style>"; emailQuoteBody = emailQuoteBody + thisEnter + "</head>"; emailQuoteBody = emailQuoteBody + thisEnter + "<body>"; emailQuoteBody = emailQuoteBody + thisEnter + "<table align='center'>"; emailQuoteBody = emailQuoteBody + thisEnter + "<tr>"; emailQuoteBody = emailQuoteBody + thisEnter + "<td align='center'>"; emailQuoteBody = emailQuoteBody + thisEnter + "<table>"; emailQuoteBody = emailQuoteBody + thisEnter + "<tr>"; emailQuoteBody = emailQuoteBody + thisEnter + "<td style='text-align:left;width:450px;'>"; emailQuoteBody = emailQuoteBody + thisEnter + Redaccion; emailQuoteBody = emailQuoteBody + thisEnter + "</td>"; emailQuoteBody = emailQuoteBody + thisEnter + "</tr>"; emailQuoteBody = emailQuoteBody + thisEnter + "</table>"; emailQuoteBody = emailQuoteBody + thisEnter + "</body>"; emailQuoteBody = emailQuoteBody + thisEnter + "</head>"; emailQuoteBody = emailQuoteBody + thisEnter + "</html>"; MailMessage msg = new MailMessage(); msg.To.Add("*****@*****.**"); msg.CC.Add(new MailAddress("*****@*****.**")); msg.From = new MailAddress("*****@*****.**"); //msg.Bcc.Add(new MailAddress("*****@*****.**")); msg.Subject = "Generación de alertas, sistema medición Yolk"; msg.Body = "Se generaron nuevas alertas del día anterior, éstas mismas las podrá consultar en el sistema en la sección de reportes de mantenimiento."; msg.IsBodyHtml = true; msg.Priority = MailPriority.Normal; AlternateView htmlView = AlternateView.CreateAlternateViewFromString(emailQuoteBody, null, "text/html"); msg.AlternateViews.Add(htmlView); SmtpClient clienteSmtp = new SmtpClient(); try { clienteSmtp.Send(msg); } catch (Exception ex) { Console.Write(ex.Message); Console.ReadLine(); } } } Obten.Close(); } Respuesta.Add("Error", Error); }); return(Respuesta.ToString()); }
public void Dispose() { Conn.Dispose(); }
public override bool IsValid(DataRow R, out string errmess, out string errfield) { if (!base.IsValid(R, out errmess, out errfield)) { return(false); } //profservice§2006§34 if (CfgFn.GetNoNullInt32(R["idser"]) <= 0) { errmess = "Bisogna specificare la prestazione"; errfield = "idser"; return(false); } string filterRitEnpals = QHS.AppAnd(QHS.CmpEq("idser", R["idser"]), QHS.CmpEq("taxkind", 3), QHS.Like("taxref", "%enpals%")); DataTable TRitEnpals = Conn.RUN_SELECT("servicetaxview", "*", null, filterRitEnpals, null, false); if (TRitEnpals.Rows.Count > 0) { errmess = "La denuncia UNIEMENS per il compenso assoggettato ad ENPALS \n\r " + "non sarà prodotta con il flusso UNIEMENS di Easy ma \n\r " + "dovrà essere eventualmente effettuata direttamente dal sito \n\r " + "http://www.inps.it/ . Si raccomanda di informare tempestivamente \n\r " + "l'ufficio competente alla trasmissione della denuncia UNIEMENS."; errfield = "idser"; MessageBox.Show(errmess, "Avviso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } bool IsAdmin = (GetSys("manage_prestazioni") != null) ? GetSys("manage_prestazioni").ToString() == "S" : false; string filter_idrelated = QHC.CmpEq("idrelated", "profservice§" + R["ycon"] + "§" + R["ncon"]); //filter_idrelated = "(idrelated="+QueryCreator.quotedstrvalue(filter_idrelated,true)+")"; DataTable Tserviceregistry = Conn.RUN_SELECT("serviceregistry", "*", null, filter_idrelated, null, null, true); if ((Tserviceregistry.Rows.Count > 0) && (R.RowState == DataRowState.Modified)) { bool error = false; string message = ""; if (R["idreg", DataRowVersion.Current].ToString() != R["idreg", DataRowVersion.Original].ToString()) { message = "Percipiente \n\r "; error = true; } if (R["description", DataRowVersion.Current].ToString() != R["description", DataRowVersion.Original].ToString()) { message = message + "Descrizione \n\r "; error = true; } if (R["start", DataRowVersion.Current].ToString() != R["start", DataRowVersion.Original].ToString()) { message = message + "Data Inizio \n\r "; error = true; } if (R["stop", DataRowVersion.Current].ToString() != R["stop", DataRowVersion.Original].ToString()) { message = message + "Data Fine \n\r "; error = true; } if (CfgFn.RoundValuta(CfgFn.GetNoNullDecimal(R["totalcost", DataRowVersion.Current])) != CfgFn.RoundValuta(CfgFn.GetNoNullDecimal(R["totalcost", DataRowVersion.Original]))) { message = message + "Lordo al beneficiario \n\r "; error = true; } if (error) { if (IsAdmin) { errmess = "L'Anagrafe delle Prestazioni è stata già generata, e risultano modificati i seguenti dati: \n\r" + message + "Adeguare anche i dati dell'Incarico."; MessageBox.Show(errmess, "Avviso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { errmess = "Risultano modificati i seguenti dati: \n\r" + message + "La modifica non è consentita perché l'Anagrafe delle Prestazioni è stata già generata.\r\n" + "Contattare il servizio assistenza o un utente con ruolo 'manage_prestazioni' "; return(false); } } } // if (CfgFn.GetNoNullInt32(R["idreg"]) == 0) { errmess = "Inserire il percipiente"; errfield = "idreg"; return(false); } if (R["description"].ToString() == "") { errmess = "Il campo descrizione è obbligatorio."; errfield = "description"; return(false); } if (R["doc"].ToString() == "") { errmess = "Il campo documento è obbligatorio e dovrebbe contenere il rif. alla fattura."; errfield = "doc"; } if (R["docdate"].ToString() == "") { errmess = "Il campo data documento è obbligatorio e dovrebbe contenere la data della fattura."; errfield = "docdate"; } //A questo controllo è stato tolto l' uguale,perchè ci sono dei casi in cui i professionisti fatturano solo spese non imponibili //anticipate per conto del committente quindi è possibile che l'importo della prestazione sia uguale a zero. Task 3750 if (CfgFn.GetNoNullDecimal(R["feegross"]) < 0) { errmess = "L'importo lordo del contratto deve essere maggiore di zero"; errfield = "feegross"; return(false); } DateTime dataInizio = (DateTime)R["start"]; DateTime dataFine = (DateTime)R["stop"]; if (dataInizio > dataFine) { errmess = "La data di fine deve essere identica o successiva a quella di inizio"; errfield = "stop"; return(false); } //Se il percipiente ha un indirizzo AP, nel form del compenso si deve scegliere o S o N String codeaddress = "07_SW_ANP"; DateTime DataInizio = (DateTime)R["start"]; object idaddresskind = Conn.DO_READ_VALUE("address", QHS.CmpEq("codeaddress", codeaddress), "idaddress"); DataTable Address = DataAccess.RUN_SELECT(Conn, "registryaddress", "*", null, QHS.AppAnd(QHS.CmpEq("idaddresskind", idaddresskind), QHS.CmpEq("idreg", R["idreg"]), QHS.CmpLe("start", DataInizio), QHS.NullOrGe("stop", DataInizio)), false); if (Address.Rows.Count > 0) { if ((R["authneeded"].ToString() != "S") && (R["authneeded"].ToString() != "N")) { errfield = "authneeded"; errmess = "Il percipiente ha un indirizzo Anagrafe delle Prestazioni, pertanto va indicato se necessita o meno dell'autorizzazione."; return(false); } } if (R["authneeded"].ToString() == "S" && R["authdoc"].ToString() == "") { errmess = "Il campo 'Documento' è obbligatorio"; errfield = "authdoc"; return(false); } if (R["authneeded"].ToString() == "S" && R["authdocdate"] == DBNull.Value) { errmess = "Il campo 'data' è obbligatorio"; errfield = "authdocdate"; return(false); } if (R["authneeded"].ToString() == "N" && R["noauthreason"].ToString() == "") { errmess = "Il campo 'Motivo' è obbligatorio"; errfield = "authdoc"; return(false); } if ((R.RowState == DataRowState.Added) && (!RowChange.IsAutoIncrement(R.Table.Columns["ncon"]))) { string filterProfService = QHS.AppAnd(QHS.CmpEq("ycon", R["ycon"]), QHS.CmpEq("ncon", R["ncon"])); int NPRESENT = Conn.RUN_SELECT_COUNT("profservice", filterProfService, true); if (NPRESENT > 0) { errmess = "Esiste già un contratto con lo stesso numero."; errfield = "ncon"; return(false); } } //Se il DS contiene la tabella registry, controlla che l'idreg abbia il CF,se SI chiama il metodo. if (R.Table.DataSet.Tables.Contains("registry") && (R.Table.DataSet.Tables["registry"].Rows.Count > 0)) { DataRow Registry = R.Table.DataSet.Tables["registry"].Rows[0]; if (Registry["cf"] != DBNull.Value) { string errori; if (!CalcolaCodiceFiscale.CodiceFiscaleValido(this.Conn, Registry, out errori)) { errmess = "Il Codice Fiscale non è valido!\n" + errori; return(false); } } } else { //Se il DS non contiene la tabella registry,controlla che l'idreg abbia il CF se SI legge la riga dal DB // e chiama il metodo. object CF = Conn.DO_READ_VALUE("registry", QHS.CmpEq("idreg", R["idreg"]), "cf"); if (CF != DBNull.Value) { DataTable TRegistry = Conn.RUN_SELECT("registry", "*", null, QHS.CmpEq("idreg", R["idreg"]), null, null, true); if (TRegistry.Rows.Count > 0) { DataRow Registry = TRegistry.Rows[0]; string errori; if (!CalcolaCodiceFiscale.CodiceFiscaleValido(this.Conn, Registry, out errori)) { errmess = "Il Codice Fiscale non è valido!\n" + errori; return(false); } } } } return(true); }
/// <summary> /// Select all Users /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <returns>User Table</returns> public DataTable SelectUser(Conn ObjConn, SqlCommand ObjSqlCommmand) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "select * from [User]"); }
public void SequencialTransaction() { Conn.BeginTransaction().Rollback(); Conn.BeginTransaction(); }
/// <summary> /// Update User /// </summary> /// <param name="ObjConn"></param> /// <param name="ObjSqlCommmand"></param> /// <param name="Password"></param> /// <param name="Status"></param> /// <param name="OnlineStatus"></param> /// <param name="RoleID"></param> /// <param name="Email"></param> /// <param name="Name"></param> /// <param name="Address"></param> /// <param name="Photo"></param> /// <param name="SessionID"></param> /// <param name="LastModifiedBy"></param> /// <returns></returns> public string UpdateUser(Conn ObjConn, SqlCommand ObjSqlCommmand,int UserID, string Password, string Status, string OnlineStatus, int RoleID, string Email, string Name, string Address, string Photo, string SessionID, string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, " UPDATE [User] SET [Password] = '" + Password + "',[Status] = '" + Status + "',[OnlineStatus] = '" + OnlineStatus + "',[RoleID] = " + RoleID + ",[Email] = '" + Email + "',[Name] = '" + Name + "',[Address] = '" + Address + "',[Photo] = '" + Photo + "',[SessionID] = '" + SessionID + "'," + "[Modified] = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',[LastModifiedBy] = '" + LastModifiedBy + "' output inserted.UserID where [UserID] = " + UserID.ToString()); }
public error Write(slice <byte> b) => s_WriteByRef?.Invoke(ref this, b) ?? s_WriteByVal?.Invoke(this, b) ?? Conn?.Write(b) ?? throw new PanicException(RuntimeErrorPanic.NilPointerDereference);
/// <summary> /// Insert User Settings /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="UserID">UserID</param> /// <param name="AttentionSound">AttentionSound</param> /// <param name="NewMessageSound">NewMessageSound</param> /// <param name="ThemeID">ThemeID</param> /// <param name="LastModifiedBy">LastModifiedBy</param> /// <returns></returns> public string InsertUserSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int UserID, string AttentionSound, string NewMessageSound, int ThemeID,string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, " INSERT INTO [UserSettings]([UserID],[AttentionSound],[NewMessageSound],[ThemeID],[Created],[LastModifiedBy])" + " VALUES (" + UserID + ",'" + AttentionSound + "','" + NewMessageSound + "'," + ThemeID + "," + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + LastModifiedBy + "')" + " Select @@IDENTITY"); }
public error RemoteAddr() => s_RemoteAddrByRef?.Invoke(ref this) ?? s_RemoteAddrByVal?.Invoke(this) ?? Conn?.RemoteAddr() ?? throw new PanicException(RuntimeErrorPanic.NilPointerDereference);
/// <summary> /// Update Group Settings /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <param name="ExpiryTime">ExpiryTime</param> /// <param name="RoutingType">RoutingType</param> /// <param name="RoutingTime">RoutingTime</param> /// <param name="LastModifiedBy">LastModifiedBy</param> /// <returns></returns> public string UpdateGroupSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID, int ExpiryTime, string RoutingType, int RoutingTime, string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, " UPDATE [GroupSettings] SET [ExpiryTime] = '" + ExpiryTime + "',[RoutingType]='" + RoutingType + "'," + "[RoutingTime]=" + RoutingTime + ",[Modified]=GETDATE(),[LastModifiedBy]='" + LastModifiedBy + "'" + " output inserted.GroupID where [GroupID] =" + GroupID); }
public override void Init() { Conn = CreateAutorecoveringConnection(); Model = Conn.CreateModel(); }
public string DeleteMessage(Conn ObjConn, SqlCommand ObjSqlCommmand, int MessageID) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "DELETE from [Message] output deleted.MessageID where MessageID = " + MessageID); }
public object ExecuteScalar(string sql, object param) { return(Conn.ExecuteScalar(ChangePrefix(sql), param , Trans, null, null)); }
public void GetSchemaForeignKeys() { var dt = Conn.GetSchema("ForeignKeys"); Assert.IsNotNull(dt); }
public string UpdateMessageHistory(Conn ObjConn, SqlCommand ObjSqlCommmand, int MessageID, int ExecutiveID, string ExecutiveIP, int CustomerID, int MessageSequence, Int16 MessageRead) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "UPDATE [Message] SET [ExecutiveID] = " + ExecutiveID.ToString() + ",[ExecutiveIP] = '" + ExecutiveIP + "',[CustomerID] = " + CustomerID.ToString() + ",[MessageSequence] = " + MessageSequence.ToString() + ",[MessageRead] =" + MessageRead.ToString() + " VALUES (" + ExecutiveID.ToString() + ",'" + ExecutiveIP + "'," + CustomerID.ToString() + "," + MessageSequence.ToString() + "','" + " output inserted.MessageID where MessageID = " + MessageID); }
public error Close() => s_CloseByRef?.Invoke(ref this) ?? s_CloseByVal?.Invoke(this) ?? Conn?.Close() ?? throw new PanicException(RuntimeErrorPanic.NilPointerDereference);
public void GetSchemaWithReservedWords() { DataTable metaDataCollections = Conn.GetSchema(System.Data.Common.DbMetaDataCollectionNames.ReservedWords); Assert.IsTrue(metaDataCollections.Rows.Count > 0, "There should be one or more ReservedWords returned."); }
public error SetDeadline(time.Time t) => s_SetDeadlineByRef?.Invoke(ref this, t) ?? s_SetDeadlineByVal?.Invoke(this, t) ?? Conn?.SetDeadline(t) ?? throw new PanicException(RuntimeErrorPanic.NilPointerDereference);
public void Execute(DBOperation radnja) { try { if (radnja == DBOperation.Save) { try { Conn.Open(); int result = Cmd.ExecuteNonQuery(); Cmd.Parameters.Clear(); } catch (Exception ex) { throw; } finally { Conn.Close(); } } if (radnja == DBOperation.SaveWithOutput) { try { Conn.Open(); int result = Cmd.ExecuteNonQuery(); } catch (Exception ex) { Conn.Close(); throw; } } if (radnja == DBOperation.GetDataSet) { try { SqlDataAdapter adapter = new SqlDataAdapter(Cmd); DS = new DataSet(); adapter.Fill(DS); } catch (Exception ex) { throw; } finally { Conn.Close(); } } if (radnja == DBOperation.GetReader) { Conn.Open(); Rdr = Cmd.ExecuteReader(CommandBehavior.CloseConnection); if (Rdr.HasRows) { Rdr.Read(); } } if (radnja == DBOperation.GetWhileReader) { Conn.Open(); Rdr = Cmd.ExecuteReader(CommandBehavior.CloseConnection); } } catch { throw; } }
public void HandleProtocol(Conn conn, Protocol proto) { dispatch.Dispatch(conn, proto); }
public configChart(Chart Grafica) { this.grafica = Grafica; db = new Conn <_cMascota>(); }
public string strConn() { Conn cn = new Conn(); return cn.conexao; }
public IEnumerable <Customer> Get() { Conn mysqlGet = new Conn(); return(mysqlGet.CustomerList()); }
public override void SetDefaults(DataTable PrimaryTable) { base.SetDefaults(PrimaryTable); SetDefault(PrimaryTable, "ayear", Conn.GetSys("esercizio")); }
private void SaveUser() { try { if (txtPassword.Text == "") { MessageBox.Show("Blank password is not allowed!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txtPassword.Text != txtRepeatPassword.Text) { MessageBox.Show("Password dosen't matched!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txtLoginName.Text == "") { MessageBox.Show("Please enter your login name!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } Conn obCon = new Conn(); SqlConnection ob = new SqlConnection(obCon.strCon); SqlCommand cmd = new SqlCommand("SP_SAVE_tblUserAccount", ob); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LoginName", SqlDbType.VarChar, 50); cmd.Parameters.Add("@FullName", SqlDbType.VarChar, 255); cmd.Parameters.Add("@Password", SqlDbType.VarChar, 255); cmd.Parameters.Add("@Designation", SqlDbType.VarChar, 50); cmd.Parameters.Add("@UserRoll", SqlDbType.VarChar, 50); cmd.Parameters.Add("@UserEmail", SqlDbType.VarChar, 50); cmd.Parameters.Add("@Telephone", SqlDbType.VarChar, 50); cmd.Parameters.Add("@Status", SqlDbType.VarChar, 50); cmd.Parameters[0].Value = txtLoginName.Text; cmd.Parameters[1].Value = txtFullName.Text; cmd.Parameters[2].Value = txtPassword.Text; cmd.Parameters[3].Value = cmbDesignation.Text; cmd.Parameters[4].Value = cmbRoll.Text; cmd.Parameters[5].Value = txtEmail.Text; cmd.Parameters[6].Value = txtTelephone.Text; if (optActive.Checked == true) { cmd.Parameters[7].Value = "Active"; } else if (optInactive.Checked == true) { cmd.Parameters[7].Value = "Inactive"; } ob.Open(); cmd.ExecuteNonQuery(); ob.Close(); UpdatePhoto(); MessageBox.Show("User profile update successfully!", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadData(); txtEmail.Text = ""; txtFullName.Text = ""; txtLoginName.Text = ""; txtPassword.Text = ""; txtRepeatPassword.Text = ""; txtTelephone.Text = ""; cmbRoll.SelectedIndex = 0; txtLoginName.Enabled = true; } catch (Exception error) { MessageBox.Show("Failed to save User information! " + error.Message.ToString(), "Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
/// <summary> /// Is User Exists /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="Login">Login</param> /// <returns>True/False</returns> public bool IsUserExists(Conn ObjConn, SqlCommand ObjSqlCommmand,string Login) { int i = ObjConn.executeselectcountquery(ObjSqlCommmand, "select COUNT(1) from [User] where [Login] = '" + Login + "'"); if (i > 0) return true; else return false; }
public virtual IList <T> FindAll() { var(query, @params) = QueryBuilder.FindAll(EntityDefinition); return(Conn.Query <T>(query, @params).ToList()); }
public DataTable SelectUserSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int UserID) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "select * from [UserSettings] where [UserID] = " + UserID); }
/// <summary> /// 关闭数据库 /// </summary> public void Close() { Conn.Close(); }
public string UpdateUserSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int UserID, string AttentionSound, string NewMessageSound, int ThemeID, string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, " UPDATE [UserSettings] SET [AttentionSound] = '" + AttentionSound + "',[NewMessageSound]='" + NewMessageSound + "'," + "[ThemeID]=" + ThemeID + ",[Modified]='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',[LastModifiedBy]='" + LastModifiedBy + "'" + " output inserted.UserID where [UserID] =" + UserID); }
public Task Connect(Conn message) { return(orchestrator.Connect(Context.ConnectionId, message)); }
/// <summary> /// Delete User Settings /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="UserID">UserID</param> /// <returns>UserID</returns> public string DeleteUserSettings(Conn ObjConn, SqlCommand ObjSqlCommmand, int UserID) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "Delete from [UserSettings] output deleted.UserID where [UserID] = " + UserID); }
//心跳 public void MsgHeatBeat(Conn conn, ProtocolBase protoBase) { conn.lastTickTime = Sys.GetTimeStamp(); Console.WriteLine("[更新心跳时间]" + conn.GetAddress()); }
/// <summary> /// Select Group based on GroupID /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <returns></returns> public DataTable SelectGroup(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "SELECT * from [Group] where [GroupID] = " + GroupID.ToString()); }
public ShoppingController(Conn context) { this._context = context; }
/// <summary> /// Update Group /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupName">GroupName</param> /// <param name="GroupEmail">GroupEmail</param> /// <param name="Status">Status</param> /// <param name="LastModifiedBy">LastModifiedBy</param> /// <returns></returns> public string UpdateGroup(Conn ObjConn, SqlCommand ObjSqlCommmand,int GroupID, string GroupName, string GroupEmail, string Status, string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "UPDATE [Group] SET [GroupName] = '" + GroupName + "',[GroupEmail]='" + GroupEmail + "',[Status]='" + Status + "',[Modified]=GETDATE(),[LastModifiedBy]='" + LastModifiedBy + "' output inserted.GroupID where GroupID = " + GroupID.ToString()); }
public ActionResult <IEnumerable <Shopping> > GetShopping(string id) { _context = HttpContext.RequestServices.GetService(typeof(Conn)) as Conn; return(_context.GetShopping(id)); }
/// <summary> /// Create Group /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupName">GroupName</param> /// <param name="GroupEmail">GroupEmail</param> /// <param name="Status">Status</param> /// <param name="LastModifiedBy">LastModifiedBy</param> /// <returns></returns> public string CreateGroup(Conn ObjConn, SqlCommand ObjSqlCommmand, string GroupName, string GroupEmail, string Status,string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "INSERT INTO [Group]([GroupName],[GroupEmail],[Status],[Created],[LastModifiedBy])" + " VALUES ('" + GroupName + "','" + GroupEmail + "','" + Status + "',GETDATE(),'" + LastModifiedBy + "')"+ " Select @@IDENTITY"); }
protected virtual void TearDown() { try { Conn.Close(); } finally { Conn = null; } }
/// <summary> /// Delete Group /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <returns></returns> public string DeleteGroup(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "DELETE from [Group] output deleted.GroupID where [GroupID] = " + GroupID.ToString()); }
/// <summary> /// Create User Group /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupID">GroupID</param> /// <param name="UserID">UserID</param> /// <param name="LastModifiedBy">LastModifiedBy</param> /// <returns></returns> public string CreateUserGroup(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID,int UserID, string LastModifiedBy) { return ObjConn.executescalarstringquery(ObjSqlCommmand, "INSERT INTO [GroupsToUsers]([GroupID],[UserID],[Created],[LastModifiedBy])" + " VALUES (" + GroupID + "," + UserID + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + LastModifiedBy + "')" + " Select @@IDENTITY"); }
/// <summary> /// Is Group Exists /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="GroupName">GroupName</param> /// <returns></returns> public bool IsGroupExists(Conn ObjConn, SqlCommand ObjSqlCommmand, string GroupName) { int i = ObjConn.executeselectcountquery(ObjSqlCommmand, "select count(1) from [User] where GroupName = '" + GroupName + "'"); if (i > 0) return true; else return false; }
/// <summary> /// Select Reply based on ReplyID /// </summary> /// <param name="ObjConn">SqlConnection</param> /// <param name="ObjSqlCommmand">SqlCommand</param> /// <param name="ReplyID">ReplyID</param> /// <returns></returns> public DataTable SelectReply(Conn ObjConn, SqlCommand ObjSqlCommmand, int ReplyID) { return ObjConn.executeSelectQuery(ObjSqlCommmand, "SELECT * from [Reply] where [ReplyID] = " + ReplyID.ToString()); }