public int Insert(BuybackResultAbsSale poco) { using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ABS-SQL"].ConnectionString)) { return (int)connection.Insert(poco); } }
public void AddCase(Case @case) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); connection.Insert(CaseTableName, ToKeyValuePairs(@case)); } }
public void AddCustomer(Customer customer) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); connection.Insert(CustomerTableName, ToKeyValuePairs(customer)); } }
private static void SetupDB() { var dbrecreated = false; using (var connection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;Initial Catalog=Master;Integrated Security=True")) { connection.Open(); try { connection.Execute(@" DROP DATABASE SimplecrudDemoWebsite; "); } catch (Exception ex) { Debug.WriteLine("database drop failed - close and reopen VS and try again:" + ex.Message); } try { connection.Execute(@" CREATE DATABASE SimplecrudDemoWebsite; "); dbrecreated = true; } catch (Exception ex) { Debug.WriteLine("database create failed - close and reopen VS and try again:" + ex.Message); } } if (!dbrecreated) return; using (var connection = Utilities.GetOpenConnection()) { connection.Execute(@" create TABLE Car (Id int IDENTITY(1,1) not null Primary Key, Make nvarchar(100) not null, ModelName nvarchar(100) not null) "); connection.Insert(new CarViewModel() { Make = "Honda", ModelName = "Civic" }); connection.Execute(@" create TABLE Users (UserId int IDENTITY(1,1) not null Primary Key, FirstName nvarchar(100) not null, LastName nvarchar(100) not null, intAge int not null) "); connection.Insert(new UserViewModel() {Age = 42, FirstName = "Jim", LastName = "Smith"}); connection.Execute(@" CREATE TABLE GUIDTest (guid uniqueidentifier NOT NULL,name varchar(50) NOT NULL, CONSTRAINT PK_GUIDTest PRIMARY KEY CLUSTERED (guid ASC))"); connection.Insert<Guid>(new GUIDTestViewModel {name = "Example"}); int x = 1; do { connection.Insert(new User { FirstName = "Jim ", LastName = "Smith " + x, Age = x }); x++; } while (x < 101); } }
///CRUD public void InserirFornecedor(Fornecedor fornecedor) { //Conectar ao Banco de Dados e dar um insert using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(Conexao01)) { conn.Open(); conn.Insert <Fornecedor>(fornecedor); } }
public bool AddActivityToActivity(int parentActivityId, int activityId) { var activityActivity = new ActivityActivity() {ActivityId = activityId, ParentActivityId = parentActivityId}; using (var conn = new SqlConnection(ConnectionString)) { conn.Insert(activityActivity); } return true; }
public bool AddActivityToRole(int roleId, int activityId) { var roleActivity = new RoleActivity() {ActivityId = activityId, RoleId = roleId}; using (var conn = new SqlConnection(ConnectionString)) { conn.Insert(roleActivity); } return true; }
public bool AddRoleToRole(int parentRoleId, int roleId) { var roleRole = new RoleRole() {RoleId = roleId, ParentRoleId = parentRoleId}; using (var conn = new SqlConnection(ConnectionString)) { conn.Insert(roleRole); } return true; }
public bool AddRoleToUser(int userId, int roleId) { var userRole = new UserRole() {Id = userId, RoleId = roleId}; using (var conn = new SqlConnection(ConnectionString)) { conn.Insert(userRole); } return true; }
public void SaveRule(Rule rule) { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); connection.Insert(rule); connection.Close(); } }
public void LogError(Error errorToLog) { Error result = null; //save info to DB using(SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["CrestDB"].ConnectionString)) { result = connection.Insert<Error>(errorToLog); } Clients.All.broadcastMessage(result); }
public void AddBookmarkRecord(string bookmarkName, object workflowInstanceId) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); connection.Insert(CaseWorkflowManager.BookmarkTableName, new Dictionary<string, object> { {CaseWorkflowManager.CaseIdColumnName, _caseId}, {CaseWorkflowManager.WorkflowinstanceidColumnName, workflowInstanceId}, {CaseWorkflowManager.BookmarkNameColumnName, bookmarkName} }); } }
public void AddMessage(CaseMessage doc) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); var dictionary = new Dictionary<string, object> { {"案件编号", doc.案件编号}, {"Content", doc.Content}, {"SenderName", doc.SenderUsername} }; connection.Insert(TableName, dictionary); } }
///CRUD public void InserirUsuario(Usuario usuario) { /*using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConexaoMyql)) * { * conn.Open(); * conn.Insert<Usuario>(usuario); * }*/ //Conectar ao Banco de Dados e dar um insert using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(Conexao01)) { conn.Open(); conn.Insert <Usuario>(usuario); } }
private static void Dapper(int eachCount) { GC.Collect();//回收资源 System.Threading.Thread.Sleep(2000);//休息2秒 //正试比拼 PerHelper.Execute(eachCount, "Dapper", () => { using (SqlConnection conn = new SqlConnection(PubConst.connectionString)) { var list = conn.Insert(GetList); } }); }
public void AddDoc(CaseDoc doc) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); var dictionary = new Dictionary<string, object> { {"文件名", doc.FileName}, {"创建人", doc.UploadUserName}, {"创建日期", doc.UploadDateTime}, {"文件路径", doc.FilePath}, {"案件编号", doc.案件编号} }; connection.Insert(CaseDocTableName, dictionary); } }
public static void Insert() { var contact = new Contact { FirstName = "New", LastName = "Contact", Email = "*****@*****.**" }; using (var cn = new SqlConnection(CONNECTION_STRING)) { var id = cn.Insert(contact); Console.WriteLine("Inserted record ID: {0}", id); } Console.ReadKey(); }
public Athlete SaveAthlete(Athlete athlete) { using (var conn = new SqlConnection(_ConnectionString)) { conn.Open(); if (athlete.Id == 0) { athlete.Id = conn.Insert(athlete); } else { conn.Update(athlete); } return athlete; } }
static void Main() { try { var connection = new SqlConnection(@"Server=localhost\sqlexpress;Database=ExperimentalStuff;Trusted_Connection=true;"); var id = new Guid("DB44BD6A-532C-4F9A-A9A0-CE32C193F467"); var grandParent = new GrandParent { Id = id, Name = "grandparent", }; Builder<Parent>.CreateListOfSize(3).Build() .ToList().ForEach(grandParent.AddParent); connection.Open(); using (var transaction = connection.BeginTransaction()) { connection.Delete<GrandParent>(new { grandParent.Id }, transaction); var insert = connection.Insert(grandParent, transaction); Console.WriteLine(insert); transaction.Commit(); } connection.Close(); Print(connection, grandParent.Id); //connection.Delete<GrandParent>(new { grandParent.Id }); connection.Dispose(); } catch (Exception exception) { Console.WriteLine(exception); } finally { Console.WriteLine("Press any key to exit."); Console.ReadKey(); } }
public static void Main() { using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection)) { sqlConnection.Open(); var supplier = new Supplier() { Address = "10 Main Street", CompanyName = "ABC Corporation" }; var supplierId = sqlConnection.Insert<Supplier>(supplier); sqlConnection.Close(); Console.WriteLine(string.Format("New Supplier Id is {0}", supplierId)); Console.WriteLine("Done. "); } }
public void WriteLog(DataRow Rows, string OperateName) { try { IDbConnection con = new System.Data.SqlClient.SqlConnection(PubConstant.hmWyglConnectionString); int iCorpID = AppGlobal.StrToInt(Global_Var.LoginCorpID); int iBranchID = AppGlobal.StrToInt(Global_Var.LoginBranchID); int iCommID = AppGlobal.StrToInt(Global_Var.LoginCommID); MobileSoft.Model.Sys.Tb_Sys_Log Item = new MobileSoft.Model.Sys.Tb_Sys_Log(); Item.CorpID = iCorpID; Item.BranchID = iBranchID; Item.CommID = iCommID; Item.LocationIP = ""; Item.ManagerCode = Rows["UserCode"].ToString(); Item.LogTime = DateTime.Now; Item.OperateName = OperateName; Item.Memo = "物管App登录"; Item.OperateURL = ""; con.Insert <MobileSoft.Model.Sys.Tb_Sys_Log>(Item); //(new BusinessRule.TWBusinRule(LoginSQLConnStr)).Sys_Log_Base_Insert(ref Item); } catch (Exception ex) { } }
/// <summary> /// Customers the CRUD. /// </summary> /// <param name="sqlconn">The sqlconn.</param> /// <remarks>http://wintersun.cnblogs.com/</remarks> private static void CustomerCRUD(SqlConnection sqlconn) { var customer = new Customers { CustomerID = "8273", CompanyName = "Newcompanyname", ContactName = "ccc", Address = "asdcasdws", ContactTitle = "asdf", City = "kuna", Country = "china", Fax = "23", Phone = "231", PostalCode = "234", Region = "asia" }; string insertflag = sqlconn.Insert<Customers>(customer); //update it var myCustomer = sqlconn.Get<Customers>(customer.CustomerID); myCustomer.ContactName = "updated name"; sqlconn.Update<Customers>(myCustomer); //delete sqlconn.Delete<Customers>(customer); }
public void PostPost(string title, string filename, int owner, DateTime date, int width, int height) { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); Posts p = new Posts() { title = title, filename = filename, owner = owner, dateuploaded = date, width = width, height = height }; var i = conn.Insert(p); } }
public Comments PostComment(int id, string comment, string username) { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); Comments c = new Comments() { dateposted = DateTime.UtcNow, item_id = id, text = comment, name = username }; Posts p = this.GetPost(id, conn); p.comments_count++; var i = conn.Insert(c); conn.Update(p); c.id = i; return c; } }
private void PersistMessage(QueueMessage message) { using (var connection = new SqlConnection(_setting.ConnectionString)) { connection.Insert(new { MessageId = message.MessageId, MessageOffset = message.MessageOffset, MessageKey = message.Key, Topic = message.Topic, QueueId = message.QueueId, QueueOffset = message.QueueOffset, Code = message.Code, Body = message.Body, RoutingKey = message.RoutingKey, CreatedTime = message.CreatedTime, ArrivedTime = message.ArrivedTime, StoredTime = DateTime.Now }, _setting.MessageTable); } }
public UserAuthorisation SaveUserAuthorisation(UserAuthorisation userAuthorisation) { var isInsert = userAuthorisation.Id.Equals(0); using (var conn = new SqlConnection(ConnectionString)) { if (isInsert) { userAuthorisation = conn.Insert(userAuthorisation, "Id"); } else { conn.Update(userAuthorisation, new Dictionary<string, object>() {{"Id", userAuthorisation.Id}}, new[] {"Id"}); } } return userAuthorisation; }
public Role SaveRole(Role role) { var isInsert = role.Id.Equals(0); using (var conn = new SqlConnection(ConnectionString)) { if (isInsert) { role = conn.Insert(role, "Id"); } else { conn.Update(role, new Dictionary<string, object>() {{"Id", role.Id}}, new[] {"Id"}); } } return role; }
public void AddApplicant(Applicant applicant) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); connection.Insert(ApplicantTableName, ToKeyValuePairs(applicant)); } }
public void AddInventor(Inventor inventor) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); connection.Insert(InventorTableName, ToKeyValuePairs(inventor)); } }
public Activity SaveActivity(Activity activity) { var isInsert = activity.Id.Equals(0); using (var conn = new SqlConnection(ConnectionString)) { if (isInsert) { activity = conn.Insert(activity, "Id"); } else { conn.Update(activity, new Dictionary<string, object>() {{"Id", activity.Id}}, new[] {"Id"}); } } return activity; }
public int Insert(BuybackVehicle poco, IDbTransaction transaction) { using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ABS-SQL"].ConnectionString)) { return (int)connection.Insert(poco, transaction); } }