public bool AddMultiple(IEnumerable <DatabaseTableModel> LogData) { try { object myObj1 = LogData.Select(x => new { PID = x.Pid, TELNO = x.TelNo }).ToArray(); using (GetConnection) { var query = "INSERT INTO [dbo].[DatabaseTable] ([PID],[TELNO]) VALUES( @PID, @TELNO)"; GetConnection.Open(); SqlMapper.Execute(GetConnection, query, param: myObj1, commandType: CommandType.Text); } return(true); } catch (Exception ex) { throw ex; } }
public bool Update(DatabaseTableModel LogData) { try { using (GetConnection) { var query = "UPDATE [dbo].[DatabaseTable] SET [PID]=@PID,[TELNO]=@TELNO WHERE [Id]=@Id"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Id", LogData.Id); parameters.Add("@PID", LogData.Pid); parameters.Add("@TELNO", LogData.TelNo); GetConnection.Open(); SqlMapper.Execute(GetConnection, query, param: parameters, commandType: CommandType.Text); return(true); } } catch (Exception ex) { throw ex; } }
public bool Add(DatabaseTableModel LogData) { try { using (GetConnection) { var query = "INSERT INTO [dbo].[DatabaseTable] ([PID],[TELNO]) VALUES( @PID, @TELNO)"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("@PID", LogData.Pid); parameters.Add("@TELNO", LogData.TelNo); GetConnection.Open(); SqlMapper.Execute(GetConnection, query, param: parameters, commandType: CommandType.Text); } return(true); } catch (Exception ex) { throw ex; } }