/// <summary> /// Get user. /// </summary> /// <param name="userId">Id of the User.</param> /// <param name="profileStatus">ProfileStatus</param> /// <param name="chapter">Chapter</param> /// <returns>company profile of user</returns> public static List <MembershipProfile> GetMembershipProfile(string userId, dynamic profileStatus, dynamic chapter) { var membershipProfileList = new List <MembershipProfile>(); using (var conn = GetConnection()) { using (SqlCommand cmd = new SqlCommand("MembershipProfile_GetDetails", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = userId; cmd.Parameters.Add("@ProfileStatus", SqlDbType.Int).Value = profileStatus != null ? profileStatus : 0; cmd.Parameters.Add("@chapter", SqlDbType.Int).Value = chapter != null ? chapter : 0; conn.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { MembershipProfile membershipProfile = new MembershipProfile(rdr.GetInt32(0).ToString(), rdr.GetInt32(1), rdr.GetInt32(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetValue(7).ToString(), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetString(13), rdr.GetString(14), rdr.GetString(15), rdr.GetString(16), rdr.GetString(17), rdr.GetString(18), rdr.GetString(19), rdr.GetString(20), rdr.GetString(21), rdr.GetDateTime(22), rdr.GetDateTime(23)); membershipProfileList.Add(membershipProfile); } } } } return(membershipProfileList); }
/// <summary> /// Updates a MembershipProfile Details /// </summary> /// <param name="membershipProfile">MembershipProfile</param> public static void UpdateMembershipProfile(MembershipProfile membershipProfile) { using (var conn = GetConnection()) { using (SqlCommand cmd = new SqlCommand("MembershipProfile_UpdateDetails", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = membershipProfile.Id; cmd.Parameters.Add("@ProfileStatus", SqlDbType.Int).Value = membershipProfile.ProfileStatus; cmd.Parameters.Add("@Chapter", SqlDbType.Int).Value = membershipProfile.Chapter; cmd.Parameters.Add("@UnitName", SqlDbType.VarChar).Value = membershipProfile.UnitName != null ? membershipProfile.UnitName : string.Empty; cmd.Parameters.Add("@GSTIN", SqlDbType.VarChar).Value = membershipProfile.GSTIN != null ? membershipProfile.GSTIN : string.Empty; cmd.Parameters.Add("@GSTcertpath", SqlDbType.VarChar).Value = membershipProfile.GSTcertpath != null ? membershipProfile.GSTcertpath : string.Empty; cmd.Parameters.Add("@IndustryStatus", SqlDbType.VarChar).Value = membershipProfile.IndustryStatus != null ? membershipProfile.IndustryStatus : string.Empty; cmd.Parameters.Add("@Address", SqlDbType.Text).Value = membershipProfile.Address != null ? membershipProfile.Address : string.Empty; cmd.Parameters.Add("@District", SqlDbType.VarChar).Value = membershipProfile.District != null ? membershipProfile.District : string.Empty; cmd.Parameters.Add("@City", SqlDbType.VarChar).Value = membershipProfile.City != null ? membershipProfile.City : string.Empty; cmd.Parameters.Add("@State", SqlDbType.VarChar).Value = membershipProfile.State != null ? membershipProfile.State : string.Empty; cmd.Parameters.Add("@Country", SqlDbType.VarChar).Value = membershipProfile.Country != null ? membershipProfile.Country : string.Empty; cmd.Parameters.Add("@Pincode", SqlDbType.VarChar).Value = membershipProfile.Pincode != null ? membershipProfile.Pincode : string.Empty; cmd.Parameters.Add("@WebsiteUrl", SqlDbType.VarChar).Value = membershipProfile.WebsiteUrl != null ? membershipProfile.WebsiteUrl : string.Empty; cmd.Parameters.Add("@ProductCategory", SqlDbType.VarChar).Value = membershipProfile.ProductCategory != null ? membershipProfile.ProductCategory : string.Empty; cmd.Parameters.Add("@ProductSubCategory", SqlDbType.VarChar).Value = membershipProfile.ProductSubCategory != null ? membershipProfile.ProductSubCategory : string.Empty; cmd.Parameters.Add("@MajorProducts", SqlDbType.Text).Value = membershipProfile.MajorProducts != null ? membershipProfile.MajorProducts : string.Empty; cmd.Parameters.Add("@AnnualTurnOver", SqlDbType.VarChar).Value = membershipProfile.AnnualTurnOver != null ? membershipProfile.AnnualTurnOver : string.Empty; cmd.Parameters.Add("@EnterpriseType", SqlDbType.VarChar).Value = membershipProfile.EnterpriseType != null ? membershipProfile.EnterpriseType : string.Empty; cmd.Parameters.Add("@Exporter", SqlDbType.VarChar).Value = membershipProfile.Exporter != null ? membershipProfile.Exporter : string.Empty; cmd.Parameters.Add("@Classification", SqlDbType.VarChar).Value = membershipProfile.Classification != null ? membershipProfile.Classification : string.Empty; cmd.Parameters.Add("@SignaturePath", SqlDbType.VarChar).Value = membershipProfile.SignaturePath != null ? membershipProfile.SignaturePath : string.Empty; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = DateTime.Now; conn.Open(); cmd.ExecuteNonQuery(); } } }
/// <summary> /// Get user. /// </summary> /// <param name="userId">Id of the User.</param> /// <returns>company profile of user</returns> public static MembershipProfile GetMembershipProfile(string userId) { using (var conn = GetConnection()) { using (SqlCommand cmd = new SqlCommand("MembershipProfile_GetDetails", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = userId; cmd.Parameters.Add("@ProfileStatus", SqlDbType.Int).Value = 0; cmd.Parameters.Add("@chapter", SqlDbType.Int).Value = 0; conn.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { MembershipProfile membershipProfile = new MembershipProfile(rdr.GetInt32(0).ToString(), rdr.GetInt32(1), rdr.GetInt32(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetValue(7).ToString(), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetString(13), rdr.GetString(14), rdr.GetString(15), rdr.GetString(16), rdr.GetString(17), rdr.GetString(18), rdr.GetString(19), rdr.GetString(20), rdr.GetString(21), rdr.GetDateTime(22), rdr.GetDateTime(23)); return(membershipProfile); } } } } return(new MembershipProfile("Profile Details Not Found")); }