//List
public List <eSunSpeedDomain.AuthorModel> GetAllAuthors()
{
List <eSunSpeedDomain.AuthorModel> lstAuthors = new List <eSunSpeedDomain.AuthorModel>();
eSunSpeedDomain.AuthorModel objModel;
string Query = "SELECT * FROM AuthorMaster";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objModel = new eSunSpeedDomain.AuthorModel();
objModel.Author_Id = DataFormat.GetInteger(dr["Author_Id"]);
objModel.Name = dr["Author_Name"].ToString();
objModel.Alias = dr["Author_Alias"].ToString();
objModel.PrintName = dr["Author_PName"].ToString();
objModel.ConnectAcc = Convert.ToBoolean(dr["Author_Connect"]);
objModel.MobileNo = dr["Author_Mobile"].ToString();
objModel.Address = dr["Author_Address"].ToString();
objModel.Street = dr["Author_Street"].ToString();
objModel.City = dr["Author_City"].ToString();
objModel.Country = dr["Author_Country"].ToString();
objModel.State = dr["Author_State"].ToString();
objModel.PinCode = dr["Author_PinCode"].ToString();
lstAuthors.Add(objModel);
}
return(lstAuthors);
}
//Save
public bool SaveAuthorMaster(eSunSpeedDomain.AuthorModel objAuthor)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Author_Name", objAuthor.Name));
paramCollection.Add(new DBParameter("@Author_Alias", objAuthor.Alias));
paramCollection.Add(new DBParameter("@Author_PrintName", objAuthor.PrintName));
paramCollection.Add(new DBParameter("@Author_ConnectAcc", objAuthor.ConnectAcc, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@Author_Address", objAuthor.Address));
//paramCollection.Add(new DBParameter("@Author_Street", objAuthor.Street));
//paramCollection.Add(new DBParameter("@Author_PinCode", objAuthor.PinCode));
//paramCollection.Add(new DBParameter("@Author_City",objAuthor.City));
paramCollection.Add(new DBParameter("@Author_State", objAuthor.State));
//paramCollection.Add(new DBParameter("@Author_Country", objAuthor.Country));
paramCollection.Add(new DBParameter("@Author_Telnumber", objAuthor.Telephone));
paramCollection.Add(new DBParameter("@Author_MobileNo", objAuthor.MobileNo));
paramCollection.Add(new DBParameter("@Author_email", objAuthor.Email));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO AuthorMaster (`Author_Name`,`Author_Alias`,`Author_PName`,`Author_Connect`,`Author_Address`," +
"`Author_State`,`Author_Telenumber`,`Author_Mobile`,`Author_Email`,`CreatedBy`) VALUES " +
"(@Author_Name,@Author_Alias,@Author_PrintName,@Author_ConnectAcc,@Author_Address," +
"@Author_State,@Author_Telnumber,@Author_MobileNo,@Author_email,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//Update
public bool UpdateAuthorMaster(eSunSpeedDomain.AuthorModel objAuthor)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Author_Name", objAuthor.Name));
paramCollection.Add(new DBParameter("@Author_Alias", objAuthor.Alias));
paramCollection.Add(new DBParameter("@Author_PrintName", objAuthor.PrintName));
paramCollection.Add(new DBParameter("@Author_ConnectAcc", objAuthor.ConnectAcc, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@Author_Address", objAuthor.Address));
paramCollection.Add(new DBParameter("@Author_Street", objAuthor.Street));
paramCollection.Add(new DBParameter("@Author_PinCode", objAuthor.PinCode));
paramCollection.Add(new DBParameter("@Author_City", objAuthor.City));
paramCollection.Add(new DBParameter("@Author_State", objAuthor.State));
paramCollection.Add(new DBParameter("@Author_Country", objAuthor.Country));
paramCollection.Add(new DBParameter("@Author_Mobile", objAuthor.MobileNo));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@Author_Id", objAuthor.Author_Id));
Query = "UPDATE AuthorMaster SET [Author_Name]=@Author_Name,[Author_Alias]=@Author_Alias,[Author_PName]=@Author_PrintName,[Author_Connect]=@Author_ConnectAcc," +
"[Author_Address]=@Address,[Author_Street]=@Author_Street,[Author_PinCode]=@Author_PinCode,[Author_City]=@Author_City,[Author_State]=@Author_State," +
"[Author_Country]=@Author_Country, [Author_Mobile]=@Author_Mobile, [ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE Author_Id=@Author_Id;";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}