public StatusDTO <BookMasterDTO> Insert(BookMasterDTO data)
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "ins_LibraryBook";
command.CommandType = CommandType.StoredProcedure;
command.Connection = dbSvc.GetConnection() as MySqlConnection;
if (data.CreatedBy != null)
{
command.Parameters.Add("@CreatedBy", MySqlDbType.Int32).Value = data.CreatedBy;
}
else
{
command.Parameters.Add("@CreatedBy", MySqlDbType.Int32).Value = DBNull.Value;
}
command.Parameters.Add("@BookName", MySqlDbType.String).Value = data.BookName;
command.Parameters.Add("@AuthorName1", MySqlDbType.String).Value = data.AuthorName1;
if (data.AuthorName2 != null)
{
command.Parameters.Add("@AuthorName2", MySqlDbType.String).Value = data.AuthorName2;
}
else
{
command.Parameters.Add("@AuthorName2", MySqlDbType.String).Value = DBNull.Value;
}
if (data.PurchaseDate != null)
{
command.Parameters.Add("@PurchaseDate", MySqlDbType.Date).Value = Convert.ToDateTime(data.PurchaseDate);
}
else
{
command.Parameters.Add("@PurchaseDate", MySqlDbType.Date).Value = DBNull.Value;
}
if (data.AccDate != null)
{
command.Parameters.Add("@AccDate", MySqlDbType.Date).Value = Convert.ToDateTime(data.AccDate);
}
else
{
command.Parameters.Add("@AccDate", MySqlDbType.Date).Value = DBNull.Value;
}
command.Parameters.Add("@AccNo", MySqlDbType.String).Value = data.AccNo;
command.Parameters.Add("@CallNo", MySqlDbType.String).Value = data.CALLNO;
command.Parameters.Add("@ISBNNO", MySqlDbType.String).Value = data.ISBNNo;
command.Parameters.Add("@Edition", MySqlDbType.String).Value = data.Edition;
command.Parameters.Add("@Publisher", MySqlDbType.String).Value = data.Publisher;
if (data.PublishingYear != null)
{
command.Parameters.Add("@PublishingYear", MySqlDbType.DateTime).Value = Convert.ToDateTime(data.PublishingYear);
}
else
{
command.Parameters.Add("@PublishingYear", MySqlDbType.DateTime).Value = DBNull.Value;
}
command.Parameters.Add("@Place", MySqlDbType.String).Value = data.Place;
command.Parameters.Add("@LocationId", MySqlDbType.Int32).Value = data.Location.LocationId;
command.Parameters.Add("@Series", MySqlDbType.String).Value = data.Series;
command.Parameters.Add("@Price", MySqlDbType.Decimal).Value = Convert.ToDecimal(data.Price);
command.Parameters.Add("@NOFCID", MySqlDbType.String).Value = data.NOFCD;
command.Parameters.Add("@BookCategoryId", MySqlDbType.Int32).Value = data.BookCategory.BookCategoryId;
MySqlDataReader rdr = command.ExecuteReader(CommandBehavior.CloseConnection);
_dtData = new DataTable();
_dtData.Load(rdr);
StatusDTO <BookMasterDTO> status = new StatusDTO <BookMasterDTO>();
return(status);
//MySqlDataReader rdr = command.ExecuteReader(CommandBehavior.CloseConnection);
//StatusDTO<BookMasterDTO> status = new StatusDTO<BookMasterDTO>();
//status.IsSuccess = true;
//status.IsException = false;
//status.ReturnObj = data;
//return status;
}
catch (Exception exp)
{
throw exp;
}
}
}
public StatusDTO <List <BookMasterDTO> > Select(BookMasterDTO data)
{
throw new NotImplementedException();
}
public StatusDTO <BookMasterDTO> Delete(BookMasterDTO data)
{
throw new NotImplementedException();
}
public StatusDTO <BookMasterDTO> Select(int bookMasterId)
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "get_LibraryBook";
command.CommandType = CommandType.StoredProcedure;
command.Connection = dbSvc.GetConnection() as MySqlConnection;
command.Parameters.Add("@BookMasterId1", MySqlDbType.Int32).Value = bookMasterId;
MySqlDataAdapter rdr = new MySqlDataAdapter(command);
_dsData = new DataSet();
rdr.Fill(_dsData);
StatusDTO <BookMasterDTO> status = new StatusDTO <BookMasterDTO>();
BookMasterDTO bookmasterdto = new BookMasterDTO();
if (_dsData != null && _dsData.Tables.Count > 0)
{
if (_dsData.Tables[0].Rows.Count > 0)
{
bookmasterdto.BookMasterId = Convert.ToInt32(_dsData.Tables[0].Rows[0]["BookMasterId"]);
bookmasterdto.BookName = _dsData.Tables[0].Rows[0]["BookName"].ToString();
bookmasterdto.AuthorName1 = _dsData.Tables[0].Rows[0]["AuthorName1"].ToString();
bookmasterdto.AuthorName2 = _dsData.Tables[0].Rows[0]["AuthorName2"].ToString();
if (!String.IsNullOrEmpty(_dsData.Tables[0].Rows[0]["PurchaseDate"].ToString()))
{
bookmasterdto.PurchaseDate = Convert.ToDateTime(_dsData.Tables[0].Rows[0]["PurchaseDate"]);
}
else
{
bookmasterdto.PurchaseDate = null;
}
bookmasterdto.AccNo = _dsData.Tables[0].Rows[0]["AccNo"].ToString();
if (!String.IsNullOrEmpty(_dsData.Tables[0].Rows[0]["AccDate"].ToString()))
{
bookmasterdto.AccDate = Convert.ToDateTime(_dsData.Tables[0].Rows[0]["AccDate"]);
}
else
{
bookmasterdto.AccDate = null;
}
bookmasterdto.CALLNO = _dsData.Tables[0].Rows[0]["CallNo"].ToString();
bookmasterdto.ISBNNo = _dsData.Tables[0].Rows[0]["ISBNNO"].ToString();
bookmasterdto.Edition = _dsData.Tables[0].Rows[0]["Edition"].ToString();
bookmasterdto.Publisher = _dsData.Tables[0].Rows[0]["Publisher"].ToString();
if (!String.IsNullOrEmpty(_dsData.Tables[0].Rows[0]["PublishingYear"].ToString()))
{
bookmasterdto.PublishingYear = Convert.ToDateTime(_dsData.Tables[0].Rows[0]["PublishingYear"]);
}
else
{
bookmasterdto.PublishingYear = null;
}
bookmasterdto.Place = _dsData.Tables[0].Rows[0]["Place"].ToString();
bookmasterdto.Series = _dsData.Tables[0].Rows[0]["Series"].ToString();
bookmasterdto.Price = Convert.ToString(_dsData.Tables[0].Rows[0]["Price"]);
bookmasterdto.NOFCD = _dsData.Tables[0].Rows[0]["NOFCID"].ToString();
bookmasterdto.BookCategory = new BookCategoryDTO();
bookmasterdto.BookCategory.BookCategoryId = Convert.ToInt32(_dsData.Tables[0].Rows[0]["BookCategoryId"]);
bookmasterdto.Location = new LocationDTO();
bookmasterdto.Location.LocationId = Convert.ToInt32(_dsData.Tables[0].Rows[0]["LocationId"]);
}
}
status.ReturnObj = bookmasterdto;
return(status);
}
catch (Exception exp)
{
throw exp;
}
}
}
