public int InsertUpdate_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { int _RetVal = 0; SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "InsertUpdate_tbl_SibblingDetails"; cmdToExecute.CommandType = CommandType.StoredProcedure; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_SibblingDetails"); objdb.GetConnStr(); cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.MemberCode)); cmdToExecute.Parameters.Add(new SqlParameter("@BrotherSister", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.BrotherSister)); cmdToExecute.Parameters.Add(new SqlParameter("@SibblingName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.SibblingName)); cmdToExecute.Parameters.Add(new SqlParameter("@MaritalStatus", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.MaritalStatus)); cmdToExecute.Parameters.Add(new SqlParameter("@Occupation", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.Occupation)); cmdToExecute.Parameters.Add(new SqlParameter("@RetVal", SqlDbType.Int, 20, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, _RetVal)); cmdToExecute.ExecuteNonQuery(); //DB.AddOutParameter(DBCmd, "@RetVal", DbType.Int32, 18); //DB.ExecuteNonQuery(DBCmd); return(Convert.ToInt32(cmdToExecute.Parameters["@RetVal"].Value)); } catch (Exception ex) { MessageBox.Show(ex.Message); return(0); } }
public DataSet Select_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "Select_tbl_SibblingDetails"; cmdToExecute.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter da = null; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; int _TotalCount = 0; try { objdb.GetConnStr(); //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_SibblingDetails"); cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.MemberCode)); da = new SqlDataAdapter(cmdToExecute); da.Fill(ds); return(ds); } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
public DataSet Search_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { try { tbl_SibblingDetailsDAL Objtbl_SibblingDetailsDAL = new tbl_SibblingDetailsDAL(); return(Objtbl_SibblingDetailsDAL.Search_Data(Objtbl_SibblingDetailsProp)); } catch (Exception ex) { throw ex; } }
public int Delete_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { try { tbl_SibblingDetailsDAL Objtbl_SibblingDetailsDAL = new tbl_SibblingDetailsDAL(); return(Objtbl_SibblingDetailsDAL.Delete_Data(Objtbl_SibblingDetailsProp)); } catch (Exception ex) { throw ex; } }
public DataSet Select_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { try { tbl_SibblingDetailsDAL Objtbl_SibblingDetailsDAL = new tbl_SibblingDetailsDAL(); DataSet dsData = Objtbl_SibblingDetailsDAL.Select_Data(Objtbl_SibblingDetailsProp); return(dsData); } catch (Exception ex) { throw ex; } }
public DataSet Search_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { try { //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_SibblingDetails"); //DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_SibblingDetailsProp.SearchBy); //DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_SibblingDetailsProp.SearchVal); //return DB.ExecuteDataSet(DBCmd); return(null); } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
public int Delete_Data(tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp) { SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "Delete_tbl_SibblingDetails"; cmdToExecute.CommandType = CommandType.StoredProcedure; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { objdb.GetConnStr(); //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_SibblingDetails"); cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_SibblingDetailsProp.MemberCode)); //DB.AddInParameter(DBCmd, "@MemberCode", DbType.String, Objtbl_SibblingDetailsProp.MemberCode); //return DB.ExecuteNonQuery(DBCmd); return(cmdToExecute.ExecuteNonQuery()); } catch (Exception ex) { MessageBox.Show(ex.Message); return(0); } }