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