public void UnSubscribeService(int UserId)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
string strSpName = "[dbo].[usp_ServiceSubscription_UnSubscribeService]";
SQLExecuteNonQuery sqlHAsy = new SQLExecuteNonQuery();
sqlHAsy.ExecuteNonQuery(strSpName, Param);
}
public void DeleteProject(int id)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@ProjectID", id));
string strSpName = "usp_DeleteProject";
SQLExecuteNonQuery sqlHAsy = new SQLExecuteNonQuery();
sqlHAsy.ExecuteNonQuery(strSpName, Param);
}
public int AddUserSubscription(int UserId, int subscribeType)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
Param.Add(new SQLParam("@SubscribeType", subscribeType));
string strSpName = "[dbo].[usp_ServiceSubscription_AddUserSubscription]";
SQLExecuteNonQuery sqlHAsy = new SQLExecuteNonQuery();
return(sqlHAsy.ExecuteNonQueryAsGivenType <int>(strSpName, Param, "@SubscriptionId"));
}
public void AddProject(ProjectInfo objInfo)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@ProjectName", objInfo.ProjectName));
Param.Add(new SQLParam("@ProjectCode", objInfo.ProjectCode));
string strSpName = "usp_AddProject";
SQLExecuteNonQuery sqlHAsy = new SQLExecuteNonQuery();
sqlHAsy.ExecuteNonQuery(strSpName, Param);
}
public void AddUser(UserInfo objInfo)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@FirstName", objInfo.FirstName));
Param.Add(new SQLParam("@LastName", objInfo.LastName));
Param.Add(new SQLParam("@UserName", objInfo.UserName));
Param.Add(new SQLParam("@Email", objInfo.Email));
Param.Add(new SQLParam("@PasswordHash", objInfo.PasswordHash));
Param.Add(new SQLParam("@PasswordSalt", objInfo.PasswordSalt));
Param.Add(new SQLParam("@Role", objInfo.Role));
string strSpName = "[dbo].[usp_ServiceSubscription_AddUser]";
SQLExecuteNonQuery sqlHAsy = new SQLExecuteNonQuery();
sqlHAsy.ExecuteNonQuery(strSpName, Param);
}