public InviteUsersBO UpdateUserInvitationSentDate(string keystring) { InviteUsersBO objResponseBO = new InviteUsersBO(); try { var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@InviteKey", SqlDbType.VarChar) { Value = keystring }; DataSet _objDataSet = SqlHelper.SqlHelper.ExecuteDataset(SqlHelper.SqlHelper.Connect(), CommandType.StoredProcedure, "Proc_UpdateInvitationSentDateByInviteGUID", sqlParams); if (_objDataSet.Tables[0].Rows.Count > 0) { var objDataRow = _objDataSet.Tables[0].Rows[0]; objResponseBO.Name = Convert.ToString(objDataRow["Name"]); objResponseBO.EmailId = Convert.ToString(objDataRow["EmailId"]); objResponseBO.Phone = Convert.ToString(objDataRow["Phone"]); objResponseBO.InvitationSentDate = Convert.ToString(objDataRow["InvitationSentDate"]); objResponseBO.IsUserRegistered = Convert.ToBoolean(objDataRow["IsUserRegistered"]); objResponseBO.InvitedBy = Convert.ToInt32(objDataRow["InvitedBy"]); objResponseBO.CreatedOn = Convert.ToString(objDataRow["CreatedOn"]); objResponseBO.InviteGuid = Convert.ToString(objDataRow["InviteGuid"]); } } catch (Exception ex) { log4netlogger.Error(ex); } return(objResponseBO); }
public bool SaveUserInviteDetails(InviteUsersBO objInviteUsersBO) { try { var sqlParams = new SqlParameter[4]; sqlParams[0] = new SqlParameter("@Name", SqlDbType.VarChar) { Value = objInviteUsersBO.Name }; sqlParams[1] = new SqlParameter("@EmailId", SqlDbType.VarChar) { Value = objInviteUsersBO.EmailId }; sqlParams[2] = new SqlParameter("@Phone", SqlDbType.VarChar) { Value = objInviteUsersBO.Phone }; sqlParams[3] = new SqlParameter("@UserId", SqlDbType.VarChar) { Value = objInviteUsersBO.UserId }; SqlHelper.SqlHelper.ExecuteNonQuery(SqlHelper.SqlHelper.Connect(), CommandType.StoredProcedure, "Proc_SaveInvitationDetails", sqlParams); } catch (Exception ex) { log4netlogger.Error(ex); } return(true); }
public bool UpdateUserInvitationSentDate(string InviteGuid) { InviteUsersBO objResponseBO = objSellffDefaultDAO.UpdateUserInvitationSentDate(InviteGuid); EmailTemplatesBO objEmailTemplatesBO = objSellffDefaultDAO.GetEmailTemplate(ConfigurationManager.AppSettings["InviteEmail"].ToString()); try { SendEmail(objResponseBO.EmailId, objResponseBO.Name, objResponseBO.InviteGuid, ConfigurationManager.AppSettings["InitationURL"].ToString(), objEmailTemplatesBO, objResponseBO.RefereUserName); } catch (Exception ex) { } return(true); }
public List <InviteUsersBO> GetInvitedUsersByUserId(int keystring) { List <InviteUsersBO> objResultList = new List <InviteUsersBO>(); try { var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@UserId", SqlDbType.Int) { Value = keystring }; DataSet _objDataSet = SqlHelper.SqlHelper.ExecuteDataset(SqlHelper.SqlHelper.Connect(), CommandType.StoredProcedure, "Proc_GetInvitationsSentByUserId", sqlParams); if (_objDataSet.Tables[0].Rows.Count > 0) { for (int i = 0; i < _objDataSet.Tables[0].Rows.Count; i++) { InviteUsersBO objResponseBO = new InviteUsersBO(); var objDataRow = _objDataSet.Tables[0].Rows[i]; objResponseBO.Name = Convert.ToString(objDataRow["Name"]); objResponseBO.EmailId = Convert.ToString(objDataRow["EmailId"]); objResponseBO.Phone = Convert.ToString(objDataRow["Phone"]); objResponseBO.InvitationSentDate = Convert.ToString(objDataRow["InvitationSentDate"]); objResponseBO.IsUserRegistered = Convert.ToBoolean(objDataRow["IsUserRegistered"]); objResponseBO.InvitedBy = Convert.ToInt32(objDataRow["InvitedBy"]); objResponseBO.CreatedOn = Convert.ToString(objDataRow["CreatedOn"]); objResponseBO.InviteGuid = Convert.ToString(objDataRow["InviteGuid"]); objResultList.Add(objResponseBO); } } } catch (Exception ex) { log4netlogger.Error(ex); } return(objResultList); }
public bool SaveUserInviteDetails(InviteUsersBO objInviteUsersBO) { return(objSellffDefaultDAO.SaveUserInviteDetails(objInviteUsersBO)); }
public IHttpActionResult SaveUserInviteDetails([FromBody] InviteUsersBO objInviteUsersBO) { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, objSellffDefaultService.SaveUserInviteDetails(objInviteUsersBO)))); }