public SetDocument GetSingle(Int32 Id)
{
SetDocument obj = new SetDocument();
try
{
string query = "select * from set_documents where ID = " + Id + "";
SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection);
mySQLDBConnect.OpenConnection();
DataTable dt = new DataTable();
SqlDataAdapter dA = new SqlDataAdapter(cmd);
dA.Fill(dt); dA.Dispose();
obj = (from x in dt.AsEnumerable()
select new SetDocument
{
Id = x.Field <Int32>("id"),
SetId = x.Field <Int32>("set_id"),
DocType = x.Field <String>("doc_type"),
DocumentUrl = x.Field <String>("document_url"),
PageCount = x.Field <Int32>("page_count"),
CreatedBy = x.Field <Int32>("created_by"),
CreatedDate = x.Field <DateTime>("created_date"),
UpdatedBy = x.Field <Int32?>("updated_by") == null ? 0 : x.Field <Int32>("updated_by"),
UpdatedDate = x.Field <DateTime?>("updated_date"),
Status = x.Field <Int32>("status"),
Version = x.Field <Int32>("version"),
}).ToList().FirstOrDefault();
mySQLDBConnect.CloseConnection();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(obj);
}
public SetDocument UpdateData(SetDocument obj)
{
try
{
obj = ISetDocumentRepo.UpdateData(obj);
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(obj);
}
public SetDocument DeleteData(Int32 Id)
{
SetDocument obj = new SetDocument();
try
{
obj = ISetDocumentRepo.DeleteData(Id);
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(obj);
}
public SetDocument UpdateData(SetDocument obj)
{
try
{
string query = obj.ObjectToQuery <SetDocument>("update");
SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection);
mySQLDBConnect.OpenConnection();
cmd.ExecuteNonQuery();
mySQLDBConnect.CloseConnection();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(obj);
}
public SetDocument PostData(SetDocument obj)
{
try
{
string query = obj.ObjectToQuery <SetDocument>("insert") + "SELECT SCOPE_IDENTITY()";
SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection);
mySQLDBConnect.OpenConnection();
// cmd.ExecuteNonQuery();
obj.Id = Convert.ToInt32(cmd.ExecuteScalar());
mySQLDBConnect.CloseConnection();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(obj);
}
public Int32 DeleteBulkData(List <Int32> Ids)
{
Int32 result = 0;
try
{
string query = "";
Ids.ForEach(Id =>
{
SetDocument obj = GetSingle(Id);
query += obj.ObjectToQuery <SetDocument>("update");
});
SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection);
mySQLDBConnect.OpenConnection();
result = cmd.ExecuteNonQuery();
mySQLDBConnect.CloseConnection();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(result);
}
