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