private static DBResultClass Insert(Coach coach) { DBResultClass result = null; try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter(GetParamName(TblCoaches.CoachName), System.Data.SqlDbType.NVarChar, 100)); param[0].Value = coach.Name; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachUserName), System.Data.SqlDbType.NVarChar, 50)); param[1].Value = coach.UserName; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachPassword), System.Data.SqlDbType.NVarChar, 50)); param[2].Value = coach.Password; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachGender), System.Data.SqlDbType.Bit)); param[3].Value = (byte)coach.Gender; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachEmail), System.Data.SqlDbType.NVarChar, 50)); param[4].Value = coach.Email; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachMobileNumber), System.Data.SqlDbType.Int)); param[5].Value = coach.PhoneNumber; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachAddress), System.Data.SqlDbType.NVarChar, 250)); param[6].Value = coach.Address; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachPhoto), System.Data.SqlDbType.Text)); using (MemoryStream ms = new MemoryStream()) { param[7].Value = ""; if (coach.UserImage != null) { coach.UserImage.Save(ms, coach.UserImage.RawFormat); param[7].Value = Convert.ToBase64String(ms.ToArray()); } } param.Add(new SqlParameter(GetParamName(TblCoaches.CoachTall), System.Data.SqlDbType.Float)); param[8].Value = coach.Height; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachWeight), System.Data.SqlDbType.Float)); param[9].Value = coach.Weight; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachBirthDay), System.Data.SqlDbType.Date)); param[10].Value = coach.BirthDay; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachJoinDate), System.Data.SqlDbType.Date)); param[11].Value = coach.JoinDate; param.Add(new SqlParameter(GetParamName(TblCoaches.DeactivateDate), System.Data.SqlDbType.Date)); param[12].Value = DateTime.MaxValue; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachSalary), System.Data.SqlDbType.Float)); param[13].Value = coach.Salary; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachPendingState), System.Data.SqlDbType.Int)); param[14].Value = coach.PendingState; param.Add(new SqlParameter(GetParamName(TblCoaches.CoachPermission), System.Data.SqlDbType.Text)); param[15].Value = coach.Permissions.ToString(); param.Add(new SqlParameter(GetParamName(TblCoaches.Comments), System.Data.SqlDbType.Text)); param[16].Value = coach.Comments; param.Add(new SqlParameter(GetParamName(TblCoaches.Theme), System.Data.SqlDbType.NVarChar, 50)); param[17].Value = coach.Theme; DAL.ExecuteCommand(StoredProcedures.InsertNewCoach.ToString(), param.ToArray()); result = new DBResultClass(DBResultClass.DBResult.Success, "Coach Inserted Successfully"); } catch (SqlException ex) { result = new DBResultClass(DBResultClass.DBResult.Failed, ex.Message); } return(result); }
public static DBResultClass Insert(Equipment equip) { DBResultClass result; try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter(GetParamName(TblEquipments.EquipmentName), System.Data.SqlDbType.NVarChar, 100)); param[0].Value = equip.Name; param.Add(new SqlParameter(GetParamName(TblEquipments.EquipmentQuantity), System.Data.SqlDbType.Int)); param[1].Value = equip.Quantity; // param.Add(new SqlParameter(GetParamName(TblEquipments.EquipmentFactory),)); result = new DBResultClass(DBResultClass.DBResult.Success, "Equipment Inserted Successfully"); } catch (SqlException ex) { result = new DBResultClass(DBResultClass.DBResult.Success, ex.Message); } return(result); }
/// <summary> /// here in UpdateDynamic i want make it to work dynamically /// instead of create same block for each dataType etc... /// [Edit: This will be need to create each method because all data type has its body and properties] /// </summary> /// <param name="ID"></param> /// <param name="pathObj"></param> /// <returns></returns> public DBResultClass UpdateDynamic(int ID, object pathObj) { //Dy will be the type of path object param //DetectType.dName(pathObj) will be name of class Type Dy; Dy = DetectType.dType(pathObj); DBResultClass result = null; try { result = new DBResultClass(DBResultClass.DBResult.Success, DetectType.dName(pathObj) + " Updated Successfully"); } catch (SqlException ex) { result = new DBResultClass(DBResultClass.DBResult.Failed, ex.Message); } return(result); }
/// <summary> /// Insert New Member in datebase with full details /// </summary> /// <param name="member"></param> /// <returns></returns> /// private static DBResultClass Insert(Member member) { DBResultClass result = null; try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter(GetParamName(TblMembers.MemberName), System.Data.SqlDbType.NVarChar, 100)); param[0].Value = member.Name; param.Add(new SqlParameter(GetParamName(TblMembers.MemberUserName), System.Data.SqlDbType.NVarChar, 50)); param[1].Value = member.UserName; param.Add(new SqlParameter(GetParamName(TblMembers.MemberPassword), System.Data.SqlDbType.NVarChar, 50)); param[2].Value = member.Password; param.Add(new SqlParameter(GetParamName(TblMembers.MemberGender), System.Data.SqlDbType.Bit)); param[3].Value = (byte)member.Gender; param.Add(new SqlParameter(GetParamName(TblMembers.MemberEmail), System.Data.SqlDbType.NVarChar, 50)); param[4].Value = member.Email; param.Add(new SqlParameter(GetParamName(TblMembers.MemberMobileNumber), System.Data.SqlDbType.Int)); param[5].Value = member.PhoneNumber; param.Add(new SqlParameter(GetParamName(TblMembers.MemberAddress), System.Data.SqlDbType.NVarChar, 250)); param[6].Value = member.Address; param.Add(new SqlParameter(GetParamName(TblMembers.MemberPhoto), System.Data.SqlDbType.Text)); using (MemoryStream ms = new MemoryStream()) { param[7].Value = ""; if (member.UserImage != null) { member.UserImage.Save(ms, member.UserImage.RawFormat); param[7].Value = Convert.ToBase64String(ms.ToArray()); } } param.Add(new SqlParameter(GetParamName(TblMembers.MemberTall), System.Data.SqlDbType.Float)); param[8].Value = member.Height; param.Add(new SqlParameter(GetParamName(TblMembers.MemberWeight), System.Data.SqlDbType.Float)); param[9].Value = member.Weight; param.Add(new SqlParameter(GetParamName(TblMembers.MemberBirthDay), System.Data.SqlDbType.Date)); param[10].Value = member.BirthDay; param.Add(new SqlParameter(GetParamName(TblMembers.MemberJoinDate), System.Data.SqlDbType.Date)); param[11].Value = member.JoinDate; param.Add(new SqlParameter(GetParamName(TblMembers.MemberCoachID), System.Data.SqlDbType.Int)); param[12].Value = member.TrainerID; param.Add(new SqlParameter(GetParamName(TblMembers.MemberSubscribePlan), System.Data.SqlDbType.Int)); param[13].Value = member.SubscriptionID; param.Add(new SqlParameter(GetParamName(TblMembers.MemberSubscriptionDateStart), System.Data.SqlDbType.Date)); param[14].Value = member.SubscriptionStartDate; param.Add(new SqlParameter(GetParamName(TblMembers.MemberSubscriptionDateEnd), System.Data.SqlDbType.Date)); param[15].Value = member.SubscriptionEndDate; param.Add(new SqlParameter(GetParamName(TblMembers.MemberDeactivateDate), System.Data.SqlDbType.Date)); param[16].Value = DateTime.MaxValue; param.Add(new SqlParameter(GetParamName(TblMembers.MemberPaidAmount), System.Data.SqlDbType.Float)); param[17].Value = member.PaidCurrecy; param.Add(new SqlParameter(GetParamName(TblMembers.MemberRestRest), System.Data.SqlDbType.Float)); param[18].Value = member.RestCurrency; param.Add(new SqlParameter(GetParamName(TblMembers.MemberPendingState), System.Data.SqlDbType.Bit)); param[19].Value = member.PendingState; param.Add(new SqlParameter(GetParamName(TblMembers.Comments), System.Data.SqlDbType.Bit)); param[20].Value = member.Comments; /* param.Add(new SqlParameter(GetParamName(TblMembers.MemberDuration), System.Data.SqlDbType.Bit)); * param[19].Value = 0;*/ // DAL.ExecuteCommand(StoredProcedures.InsertNewMember.ToString(), param.ToArray()); result = new DBResultClass(DBResultClass.DBResult.Success, "Member Inserted Successfully"); } catch (SqlException ex) { result = new DBResultClass(DBResultClass.DBResult.Failed, ex.Message); } return(result); }