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