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