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