Example #1
0
        public List <Client_AccountManager> getClient_AccountManager(int clientId)
        {
            _param = new SqlParameter[] { new SqlParameter("@clientId", clientId) };
            _dt    = _sf.returnDTWithProc_executeReader("p_tblClient_AccountManager_get", _param);
            List <Client_AccountManager> listAM = new List <Client_AccountManager>();

            if (_dt.Rows.Count > 0)
            {
                foreach (DataRow row in _dt.Rows)
                {
                    Client_AccountManager am = new Client_AccountManager();
                    am.c_amId         = Convert.ToInt32(row["c_amId"]);
                    am.clientId       = Convert.ToInt32(row["clientId"]);
                    am.accountManager = Convert.ToString(row["accountManager"]);
                    am.contactNo      = Convert.ToString(row["contactNo"]);
                    am.emailId        = Convert.ToString(row["emailId"]);
                    listAM.Add(am);
                }
            }
            return(listAM);
        }
Example #2
0
 public int saveClient_AccountManager(Client_AccountManager am)
 {
     _param = new SqlParameter[] { new SqlParameter("@c_amId", am.c_amId), new SqlParameter("@clientId", am.clientId), new SqlParameter("@accountManager", am.accountManager), new SqlParameter("@contactNo", am.contactNo), new SqlParameter("@emailId", am.emailId) };
     return(_sf.executeNonQueryWithProc("p_tblClient_AccountManager_save", _param));
 }