public List<ContactUsExt> GetContactUs() { List<ContactUsExt> list = new List<ContactUsExt>(); string[] Code = new string[] { "PhoneForPartner", "EmailForPartner", "FaxForPartner" }; ContactUsExt obj = new ContactUsExt(); for(int i=0;i<Code.Length;i++) { var value = Code[i]; obj.Values = GetValue(value); if (obj.Values == "+33-184883175") { obj.Phone = obj.Values; } else if (obj.Values == "*****@*****.**") { obj.Email = obj.Values; } else if(obj.Values=="") { obj.Fax = obj.Values; } } list.Add(obj); return list; }
public string GetValue(String Code) { // List<ContactUsExt> list = new List<ContactUsExt>(); DataTable dt = new DataTable(); SQLCon.Open(); SqlCommand cmd = new SqlCommand("B_Ex_GetContactUs_BizTbl_Parameter_SP", SQLCon); cmd.Parameters.AddWithValue("@code", Code); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); SQLCon.Close(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { ContactUsExt EmailObj = new ContactUsExt(); Code = dr["value"].ToString(); } } return Code; }