private void InsertTransaction(Int64 userid, string transactionnumber, string amount, int tokencredit,
int tokenId)
{
TokenModel token = GetTokenById(tokenId);
DateTime tokenExpiresOn = DateTime.UtcNow.AddDays(token.ExpireDurationInDays);
using (var db = new UnseentalentdbDataContext())
{
var objpayment = new PaymentTransaction();
objpayment.Amount = Convert.ToDouble(amount);
objpayment.IsActive = true;
objpayment.IsDeleted = false;
objpayment.TokenId = tokenId;
objpayment.TransactionDate = DateTime.UtcNow;
objpayment.TransactionNumber = transactionnumber;
objpayment.UserId = userid;
db.PaymentTransactions.InsertOnSubmit(objpayment);
db.SubmitChanges();
var objtoken = new Managetoken();
objtoken.CreateDate = DateTime.UtcNow;
objtoken.IsActive = true;
objtoken.TokenId = tokenId;
objtoken.UserId = userid;
objtoken.UniqueTokenId = "UST-" + CommonHelpers.GetUniqueKey(10);
objtoken.WillExpireOn = tokenExpiresOn;
objtoken.RemainingUploadCount = token.NoOfUploadsAllowed;
db.Managetokens.InsertOnSubmit(objtoken);
db.SubmitChanges();
}
}
public bool VerifyEmail(Int64 id, string type)
{
string res = ""; //Not exist
var objdbcontext = new UnseentalentdbDataContext();
try
{
// objdbcontext.Connection.Open();
User user = objdbcontext.Users.FirstOrDefault(u => u.Id == id);
if (user != null)
{
user.IsActive = true;
objdbcontext.SubmitChanges();
return true;
}
else
{
return false;
}
}
catch
{
return false;
}
finally
{
objdbcontext.Connection.Close();
}
}
public string EventAction(ActionModel model)
{
string value = "";
using (var db = new UnseentalentdbDataContext())
{
Event events = db.Events.FirstOrDefault(t => t.Id == Convert.ToInt64(model.ID));
if (events != null)
{
switch (model.Type)
{
case ActionType.Delete:
events.IsDeleted = true;
value = "1";
break;
case ActionType.Block:
events.IsActive = false;
value = "2";
break;
case ActionType.UnBlock:
events.IsActive = true;
value = "3";
break;
default:
break;
}
db.SubmitChanges();
}
else
{
value = "0";
}
return value;
}
}
public bool SaveVideoComments(ReqAddComment objReq)
{
bool rst = false;
try
{
using (var db = new UnseentalentdbDataContext())
{
var objNew = new Comment();
objNew.CreatedDate = DateTime.UtcNow;
objNew.VideoId = Convert.ToInt64(objReq.videoId);
objNew.IsActive = true;
objNew.IsDeleted = false;
objNew.UserId = Convert.ToInt64(objReq.userId);
objNew.CommentText = objReq.commentText;
db.Comments.InsertOnSubmit(objNew);
db.SubmitChanges();
rst = true;
}
}
catch
{
}
return rst;
}
public int UserRegistration(ReqRegistration objReq)
{
int rst = 0;
try
{
using (var db = new UnseentalentdbDataContext())
{
User user = db.Users.FirstOrDefault(p => p.Email == objReq.emailId.ToLower());
if (user == null)
{
var objNew = new User();
objNew.UserName = objReq.userName;
objNew.Email = objReq.emailId.ToLower();
objNew.Password = objReq.password;
objNew.CreatedDate = DateTime.UtcNow;
objNew.IsActive = false;
objNew.IsDeleted = false;
objNew.IsToken = true;
objNew.ProfilePic = objReq.image;
objNew.NumberOfToken = 0;
db.Users.InsertOnSubmit(objNew);
db.SubmitChanges();
/*var objRole = new tbl_userrole();
objRole.createdate = DateTime.UtcNow;
objRole.isactive = false;
objRole.userid = objNew.id;
objRole.isdeleted = false;
objRole.userrole = 2;
db.tbl_userroles.InsertOnSubmit(objRole);*/
var objRole = new UserRole();
objRole.UserId = objNew.Id;
Role firstOrDefault =
GetAllRole().FirstOrDefault(r => r.Name == CommonHelpers.ToEnumDescription(RolesEnum.User));
objRole.RoleId = firstOrDefault.Id;
db.UserRoles.InsertOnSubmit(objRole);
db.SubmitChanges();
rst = 1; //Successfully Registred
SendVerifyEmail(objReq.emailId.ToLower(), "1", objNew.Id);
}
else if (user.IsActive == false)
{
rst = 1; //Successfully Registred
SendVerifyEmail(objReq.emailId.ToLower(), "1", user.Id);
}
else
{
rst = 3; //Email Id already exists
}
}
}
catch
{
rst = 2; //Error Occured
}
return rst;
}
public int SaveUploadedFileDetails(UploadedFile objReq)
{
try
{
var objUser = new CurrentUser();
using (var db = new UnseentalentdbDataContext())
{
var objNew = new Video();
objNew.UserId = objUser.userid;
objNew.EventId = objReq.SelectedEvent;
objNew.VideoPath = objReq.FileUrl;
objNew.VideoTitle = objReq.FileName;
objNew.VideoDesc = objReq.Description;
objNew.CreatedDate = objReq.CreatedAt;
objNew.IsActive = true;
objNew.IsDeleted = false;
objNew.TokenUniqueId = objReq.SelectedToken;
objNew.CategoryId = objReq.SelectedCategory;
db.Videos.InsertOnSubmit(objNew);
db.SubmitChanges();
Managetoken tokenUsed = db.Managetokens.FirstOrDefault(t => t.UniqueTokenId == objReq.SelectedToken);
if (tokenUsed != null) tokenUsed.RemainingUploadCount -= 1;
db.SubmitChanges();
return 1;
}
}
catch
{
return 0;
}
}
public string SaveEventPost(ReqSaveEventPost objReq)
{
string rst = "0";
try
{
using (var db = new UnseentalentdbDataContext())
{
var objNew = new Video();
objNew.CreatedDate = DateTime.UtcNow;
objNew.EventId = Convert.ToInt64(objReq.eventId);
objNew.IsActive = true;
objNew.IsDeleted = false;
objNew.UserId = Convert.ToInt64(objReq.userId);
objNew.VideoDesc = "";
objNew.VideoTitle = objReq.postText;
objNew.VideoPath = objReq.file;
db.Videos.InsertOnSubmit(objNew);
db.SubmitChanges();
rst = "1";
}
}
catch
{
}
return rst;
}
public bool SaveEditEvents(GetAllevents objReq)
{
bool rst = false;
try
{
using (var db = new UnseentalentdbDataContext())
{
var objUser = new CurrentUser();
if (objReq.eventid == 0)
{
var objNew = new Event();
objNew.CreatorId = objUser.userid;
objNew.CreateDate = DateTime.UtcNow;
objNew.EventDesc = objReq.eventdesc;
objNew.EventTitle = objReq.eventtitle;
objNew.EventStartDate = Convert.ToDateTime(objReq.eventstartdate);
objNew.EventEndDate = Convert.ToDateTime(objReq.eventstartdate).AddDays(42);
objNew.IsActive = true;
objNew.IsDeleted = false;
db.Events.InsertOnSubmit(objNew);
if (!string.IsNullOrWhiteSpace(objReq.eventImage))
objNew.EventImage = objReq.eventImage;
db.SubmitChanges();
rst = true;
}
else
{
Event evt = db.Events.FirstOrDefault(e => e.Id == objReq.eventid);
if (evt != null)
{
evt.CreateDate = DateTime.UtcNow;
evt.EventDesc = objReq.eventdesc;
evt.EventTitle = objReq.eventtitle;
evt.EventStartDate = Convert.ToDateTime(objReq.eventstartdate);
evt.EventEndDate = Convert.ToDateTime(objReq.eventstartdate).AddDays(42);
if (!string.IsNullOrWhiteSpace(objReq.eventImage))
evt.EventImage = objReq.eventImage;
}
db.SubmitChanges();
rst = true;
}
}
}
catch
{
}
return rst;
}
public string PostVote(ReqVote objReq)
{
string rst = "0";
try
{
if (!string.IsNullOrWhiteSpace(objReq.postId))
{
using (var db = new UnseentalentdbDataContext())
{
Vote votedByUser =
db.Votes.FirstOrDefault(x => x.UserId == Convert.ToInt64(objReq.userId) &&
x.VideoId == Convert.ToInt64(objReq.postId));
if (votedByUser == null)
{
var objNew = new Vote();
objNew.VideoId = Convert.ToInt64(objReq.postId);
objNew.UserId = Convert.ToInt64(objReq.userId);
objNew.IsVote = objReq.isLike == "True";
objNew.CreatedDate = DateTime.UtcNow;
db.Votes.InsertOnSubmit(objNew);
}
else
{
votedByUser.IsVote = objReq.isLike == "True";
votedByUser.CreatedDate = DateTime.UtcNow;
}
db.SubmitChanges();
rst = "1";
}
}
}
catch
{
}
return rst;
}
public string PostContactUs(ReqContactUs objReq)
{
string rst = "0";
if (!string.IsNullOrWhiteSpace(objReq.emailId))
{
try
{
using (var db = new UnseentalentdbDataContext())
{
var objNew = new ContactInfo();
objNew.contactName = objReq.name;
objNew.emailId = objReq.emailId;
objNew.description = objReq.description;
db.ContactInfos.InsertOnSubmit(objNew);
db.SubmitChanges();
rst = "1";
}
}
catch
{
}
}
return rst;
}