/// <summary> /// This Method is used to Delete data into tbl_MemberShip table /// </summary> /// <param name="objMemberShip">ID and Action</param> /// <returns>1 for success and -1 for fail</returns> public string DeleteMemberShip(PropMemberShipPlan objMemberShip, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_MembersipPlan", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); try { cmd.Parameters.AddWithValue("@ID", objMemberShip.membershipID); cmd.Parameters.AddWithValue("@Action", "Delete"); return(cmd.ExecuteNonQuery().ToString()); } catch (Exception showError) { throw showError; } finally { cmd.Dispose(); objCon.Con.Close(); objCon.Con.Dispose(); } } else { return("Not Valid"); } }
/// <summary> /// This Method is used to Post data into tbl_MemberShip table /// </summary> /// <param name="objMemberShip">JobType,MemberShip Name,</param> /// <returns>1 for success and -1 for fail</returns> public string InsertMemberShip(PropMemberShipPlan objMemberShip, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_MembersipPlan", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); try { cmd.Parameters.AddWithValue("@PlanName", objMemberShip.planName); cmd.Parameters.AddWithValue("@mDuration", Convert.ToDouble(objMemberShip.duration)); cmd.Parameters.AddWithValue("@Cost", Convert.ToDouble(objMemberShip.cost)); cmd.Parameters.AddWithValue("@Action", "Add"); return(cmd.ExecuteNonQuery().ToString()); } catch (Exception showError) { throw showError; } finally { cmd.Dispose(); objCon.Con.Close(); objCon.Con.Dispose(); } } else { return("Not Valid"); } }
/// <summary> /// This Method is used to Select data /// </summary> /// <param name="objCategory">Action</param> /// <returns>1 for success and -1 for fail</returns> public string RecordSelect(PropMemberShipPlan objProperty) { DllMemberShipPlan objDal = new DllMemberShipPlan(); try { return(objDal.SelectMemberShip(objProperty)); } catch (Exception info) { throw info; } finally { objDal = null; } }
/// <summary> /// This Method is used to Delete data /// </summary> /// <param name="objCategory">ID and Action</param> /// <returns>1 for success and -1 for fail</returns> public string RecordDelete(PropMemberShipPlan objProperty, string UserName) { DllMemberShipPlan objDal = new DllMemberShipPlan(); try { return(objDal.DeleteMemberShip(objProperty, UserName)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string SelectMemberShip(int flag) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropMemberShipPlan propMemberShip = new PropMemberShipPlan(); propMemberShip.status = flag; BllMemberShip objMemberShip = new BllMemberShip(); str = objMemberShip.RecordSelect(propMemberShip); return(str); } else { return("Error in Authentication"); } }
public string InsertMemberShip(string MemberShipP, float duration, float cost) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropMemberShipPlan propcat = new PropMemberShipPlan(); propcat.planName = MemberShipP; propcat.duration = duration; propcat.cost = cost; BllMemberShip objMemberShip = new BllMemberShip(); str = objMemberShip.RecordInsert(propcat, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
public string UpdateMemberShip(string Name, float duration, float cost, int ID) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropMemberShipPlan propMemberShip = new PropMemberShipPlan(); propMemberShip.planName = Name; propMemberShip.duration = duration; propMemberShip.cost = cost; propMemberShip.membershipID = ID; BllMemberShip objMemberShip = new BllMemberShip(); str = objMemberShip.RecordUpdate(propMemberShip, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
/// <summary> /// This Method is used to Select data from tbl_MemberShip table /// </summary> /// <param name="objMemberShip">Action</param> /// <returns>1 for success and -1 for fail</returns> public string SelectMemberShip(PropMemberShipPlan objMemberShip) { SqlCommand cmd = new SqlCommand("proc_MembersipPlan", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "View"); cmd.Parameters.AddWithValue("@status", objMemberShip.status); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "MemberShipPlan"); objCon.Con.Close(); return(ds.GetXml()); }