//My Friends End//
public static DBReturnCode GetActivityMemory(string ActivityID, out DataTable dtResult)
{
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@ActivityID", ActivityID);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_MemoryLoadByActivity", out dtResult, SQLParams);
return(retCode);
}
public static DBReturnCode GetVideo(string ActivityId, out DataTable dtResult)
{
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@SourceId", ActivityId);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_ActivityLoadByVideo", out dtResult, SQLParams);
return(retCode);
}
public static DBReturnCode GetCurrentUsers(string UserId, out DataTable dtResult)
{
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@UserId", UserId);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_UserMasterLoadByKey", out dtResult, SQLParams);
return(retCode);
}
public string MyExchanges()
{
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string UserId = objGlobalDefault.ID;
string jsonString = "";
DataTable dtResult;
DefaultManager.DBReturnCode retCode = DefaultManager.MyExchanges(UserId, out dtResult);;
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
jsonString = "";
foreach (DataRow dr in dtResult.Rows)
{
jsonString += "{";
foreach (DataColumn dc in dtResult.Columns)
{
jsonString += "\"" + dc.ColumnName + "\":\"" + escapejosndata(dr[dc].ToString().Replace("\r\n", " ")) + "\",";
}
jsonString = jsonString.Trim(',') + "},";
}
jsonString = "{\"Session\":\"1\",\"retCode\":\"1\",\"MyExchanges\":[" + jsonString.Trim(',') + "]}";
dtResult.Dispose();
return(jsonString);
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public string CreateExchange(string ExchangeName)
{
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string ID = objGlobalDefault.ID;
Guid UserId = new Guid(ID);
//string ID = "";
//Guid UserId = new Guid("B8D585D0-B012-4A0C-824A-DE129243AAB7");
//Guid UserId = new Guid("f22c3eac-e861-4366-b1cb-001be4927779");
//string UserId = "B8D585D0-B012-4A0C-824A-DE129243AAB7";
DateTime CreatedDate = DateTime.Now;
bool IsDeleted = false;
//Guid ModifiedBy = new Guid("B8D585D0-B012-4A0C-824A-DE129243AAB7");
Guid ModifiedBy = new Guid("f22c3eac-e861-4366-b1cb-001be4927779");
DateTime ModifiedDate = DateTime.Now;
string jsonString = "";
DefaultManager.DBReturnCode retCode = DefaultManager.CreateExchange(ExchangeName, UserId, CreatedDate, IsDeleted, ModifiedBy, ModifiedDate);
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public static DBReturnCode GetChildId(string email, out DataTable dtResult)
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@email", email);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_UserMaserLoadByEmail", out dtResult, sqlParams);
return(retCode);
}
// Household Members :: Kashif ///
public static DBReturnCode MyHouseHoldMember(string UserId, out DataTable dtResult)
{
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@UserId", UserId);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_UserRelationLoadByRoles", out dtResult, SQLParams);
return(retCode);
}
public string GroupName(string GroupID)
{
string jsonString = "";
DataTable dtResult;
DefaultManager.DBReturnCode retCode = DefaultManager.MyGroup(GroupID, out dtResult);;
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
jsonString = "";
foreach (DataRow dr in dtResult.Rows)
{
jsonString += "{";
foreach (DataColumn dc in dtResult.Columns)
{
jsonString += "\"" + dc.ColumnName + "\":\"" + escapejosndata(dr[dc].ToString().Replace("\r\n", " ")) + "\",";
}
jsonString = jsonString.Trim(',') + "},";
}
jsonString = "{\"Session\":\"1\",\"retCode\":\"1\",\"MyGroup\":[" + jsonString.Trim(',') + "]}";
dtResult.Dispose();
return(jsonString);
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
/// <returns>Photo & Videos</returns>
public static DBReturnCode MyGroup(string GroupID, out DataTable dtResult)
{
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@GroupID", GroupID);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_GroupNameLoadByGroupId", out dtResult, SQLParams);
return(retCode);
}
public static DBReturnCode DeleteExchange(string GroupID)
{
int rowsAffected = 0;
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@GroupID", GroupID);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_DeleteGroup", out rowsAffected, SQLParams);
return(retCode);
}
public static DBReturnCode DeleteActivity(string ID)
{
int rowsAffected = 0;
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@ID", ID);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_DeleteActivity", out rowsAffected, SQLParams);
return(retCode);
}
public static DBReturnCode DeleteHousehold(string Id)
{
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string UserId = objGlobalDefault.ID;
int rowsAffected = 0;
SqlParameter[] SQLParams = new SqlParameter[1];
SQLParams[0] = new SqlParameter("@Id", Id);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_DeleteUserRelation", out rowsAffected, SQLParams);
return(retCode);
}
public string AddDauhther(int Role, string firstName, string Birth, string city, string State, string Time, string Weight, string Weight1, string Length, string Head)
{
DefaultManager.DBReturnCode retCode = DefaultManager.AddDauhtherPet(Role, firstName, Birth, city, State, Time, Weight, Weight1, Length, Head);;
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public string DeleteHousehold(string Id)
{
DefaultManager.DBReturnCode retCode = DefaultManager.DeleteHousehold(Id);
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public string AddHouseMember(int Role, string AC, string email, string firstName, string lastName, string Birth, string city, string State, string Time, string Weight, string Weight1, string Length, string Head)
{
DefaultManager.DBReturnCode retCode = DefaultManager.AddHouseholdMember(Role, AC, email, firstName, lastName, Birth, city, State, Time, Weight, Weight1, Length, Head);;
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public string DeleteActivity(string ID)
{
//Guid UserId = new Guid("B8D585D0-B012-4A0C-824A-DE129243AAB7");
DefaultManager.DBReturnCode retCode = DefaultManager.DeleteActivity(ID);
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int MemoryTypeId = 1;
int MemReferId = 3;
string MemoryTittle = "this is test";
string Description = "";
DateTime MemoryDate = DateTime.Now;
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string CreadtedBy = objGlobalDefault.ID;
bool IsDeleted = false;
bool IsAlbum = true;
string SourceId = Request.QueryString["ID"];
string filename = FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(Server.MapPath(@"ImgUpload\" + filename.Trim()));
string path = @"ImgUpload\" + filename.Trim();
int rowsAffected = 0;
SqlParameter[] SQLParams = new SqlParameter[10];
SQLParams[0] = new SqlParameter("@MemoryTypeId", MemoryTypeId);
SQLParams[1] = new SqlParameter("@MemReferId", MemReferId);
SQLParams[2] = new SqlParameter("@SourceId", SourceId);
SQLParams[3] = new SqlParameter("@MemoryTitle", MemoryTittle);
SQLParams[4] = new SqlParameter("@Description", Description);
SQLParams[5] = new SqlParameter("@MemoryDate", MemoryDate);
SQLParams[6] = new SqlParameter("@IsAlbum", IsAlbum);
SQLParams[7] = new SqlParameter("@ImageUrl", path);
SQLParams[8] = new SqlParameter("@CreatedBy", CreadtedBy);
SQLParams[9] = new SqlParameter("@IsDeleted", IsDeleted);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_AddMemory", out rowsAffected, SQLParams);
if (retCode == DefaultManager.DBReturnCode.SUCCESS)
{
Successlbl.Visible = true;
}
else
{
Unsuccesslbl.Visible = true;
}
//DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_GroupsAddUpdate", out rowsAffected, SQLParams);
}
protected void Button1_Click(object sender, EventArgs e)
{
string sUserName = txt_Email.Text;
string sPassword = txt_Password.Text;
DefaultManager.DBReturnCode retCode = DefaultManager.UserLogin(sUserName, sPassword);
if (retCode == DefaultManager.DBReturnCode.SUCCESS)
{
Response.Redirect("Timeline.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
}
public string UpdateActivity(string ID, Guid GroupID, string ActivityName)
{
DateTime ActivityDate = DateTime.Now;
Guid CreatedBy = new Guid("f22c3eac-e861-4366-b1cb-001be4927779");
bool IsDeleted = false;
DefaultManager.DBReturnCode retCode = DefaultManager.UpdateActivity(ID, GroupID, ActivityName, ActivityDate, CreatedBy, IsDeleted);
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public static DBReturnCode UpdateActivity(string ID, Guid GroupID, string ActivityName, DateTime ActivityDate, Guid CreatedBy, bool IsDeleted)
{
int rowsAffected = 0;
SqlParameter[] SQLParams = new SqlParameter[6];
SQLParams[0] = new SqlParameter("@GroupID", GroupID);
SQLParams[1] = new SqlParameter("@ActivityName", ActivityName);
SQLParams[2] = new SqlParameter("@ActivityDate", ActivityDate);
SQLParams[3] = new SqlParameter("@CreatedBy", CreatedBy);
SQLParams[4] = new SqlParameter("@IsDeleted", IsDeleted);
SQLParams[5] = new SqlParameter("@ID", ID);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_ActivityAddUpdate", out rowsAffected, SQLParams);
return(retCode);
}
public static DBReturnCode UserLogin(string sUserName, string sPassword)
{
HttpContext.Current.Session["LoginUser"] = null;
DataTable dtResult;
GlobalDefault objGlobalDefault;
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@Email", sUserName);
sqlParams[1] = new SqlParameter("@Password", sPassword);
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_UserMasterLoadByKey", out dtResult, sqlParams);
if (DefaultManager.DBReturnCode.SUCCESS == retCode)
{
objGlobalDefault = new GlobalDefault();
objGlobalDefault.ID = (dtResult.Rows[0]["ID"].ToString());
objGlobalDefault.MemorEbookName = dtResult.Rows[0]["MemorEbookName"].ToString();
objGlobalDefault.Password = dtResult.Rows[0]["Password"].ToString();
objGlobalDefault.FirstName = dtResult.Rows[0]["FirstName"].ToString();
objGlobalDefault.LastName = dtResult.Rows[0]["LastName"].ToString();
objGlobalDefault.Birthday = Convert.ToDateTime(dtResult.Rows[0]["Birthday"]);
objGlobalDefault.MyImageUrl = dtResult.Rows[0]["MyImageUrl"].ToString();
objGlobalDefault.IsLocationSeriveActivated = Convert.ToBoolean(dtResult.Rows[0]["IsLocationSeriveActivated"]);
objGlobalDefault.IsUser = Convert.ToBoolean(dtResult.Rows[0]["IsUser"]);
objGlobalDefault.City = dtResult.Rows[0]["City"].ToString();
objGlobalDefault.StateId = Convert.ToInt64(dtResult.Rows[0]["StateId"]);
objGlobalDefault.MyRole = Convert.ToInt64(dtResult.Rows[0]["MyRole"]);
objGlobalDefault.CreatedBy = dtResult.Rows[0]["CreatedBy"].ToString();
objGlobalDefault.CreatedDate = Convert.ToDateTime(dtResult.Rows[0]["CreatedDate"]);
objGlobalDefault.ModifiedBy = dtResult.Rows[0]["ModifiedBy"].ToString();
//objGlobalDefault.ModifiedDate = Convert.ToDateTime(dtResult.Rows[0]["ModifiedDate"]);
objGlobalDefault.IsDeleted = Convert.ToBoolean(dtResult.Rows[0]["IsDeleted"]);
objGlobalDefault.DeletedBy = dtResult.Rows[0]["DeletedBy"].ToString();
//objGlobalDefault.DeletedDate = Convert.ToDateTime(dtResult.Rows[0]["DeletedDate"]);
objGlobalDefault.PhoneNo = dtResult.Rows[0]["PhoneNo"].ToString();
objGlobalDefault.UserName = dtResult.Rows[0]["UserName"].ToString();
HttpContext.Current.Session["LoginUser"] = objGlobalDefault;
//if (objGlobalDefault.UserType == "Admin")
// GetAuthorizedFormList();
}
return(retCode);
}
// Household Members :: Kashif ///
// Invitation Send For Group Membership //
public static DBReturnCode ExchangeInvitation(string ExchangeName, Guid UserId, DateTime CreatedDate, bool IsDeleted, Guid ModifiedBy, DateTime ModifiedDate)
{
int rowsAffected = 0;
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string Id = objGlobalDefault.ID;
SqlParameter[] SQLParams = new SqlParameter[10];
SQLParams[0] = new SqlParameter("@DeletedDate", ModifiedDate);
SQLParams[1] = new SqlParameter("@UserId", UserId);
SQLParams[2] = new SqlParameter("@GroupName", ExchangeName);
SQLParams[3] = new SqlParameter("@CreatedBy", UserId);
SQLParams[4] = new SqlParameter("@CreatedDate", CreatedDate);
SQLParams[5] = new SqlParameter("@ModifiedBy", ModifiedBy);
SQLParams[6] = new SqlParameter("@ModifiedDate", ModifiedDate);
SQLParams[7] = new SqlParameter("@IsDeleted", IsDeleted);
SQLParams[8] = new SqlParameter("@DeletedBy", ModifiedBy);
SQLParams[9] = new SqlParameter("@ID", Id);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_GroupsAddUpdate", out rowsAffected, SQLParams);
return(retCode);
}
public static DBReturnCode AddUser(string ExchangeName, Guid UserId, DateTime CreatedDate, bool IsDeleted, Guid ModifiedBy, DateTime ModifiedDate)
{
int rowsAffected = 0;
//string DeletedBy = "";
String ID = "0";
SqlParameter[] SQLParams = new SqlParameter[10];
SQLParams[0] = new SqlParameter("@DeletedDate", ModifiedDate);
SQLParams[1] = new SqlParameter("@UserId", UserId);
SQLParams[2] = new SqlParameter("@GroupName", ExchangeName);
SQLParams[3] = new SqlParameter("@CreatedBy", UserId);
SQLParams[4] = new SqlParameter("@CreatedDate", CreatedDate);
SQLParams[5] = new SqlParameter("@ModifiedBy", ModifiedBy);
SQLParams[6] = new SqlParameter("@ModifiedDate", ModifiedDate);
SQLParams[7] = new SqlParameter("@IsDeleted", IsDeleted);
SQLParams[8] = new SqlParameter("@DeletedBy", ModifiedBy);
SQLParams[9] = new SqlParameter("@ID", ID);
DefaultManager.DBReturnCode retCode = DefaultManager.ExecuteNonQuery("Proc_GroupsAddUpdate", out rowsAffected, SQLParams);
return(retCode);
}
public string UserLogin(string sUserName, string sPassword)
{
DefaultManager.DBReturnCode retCode = DefaultManager.UserLogin(sUserName, sPassword);
if (retCode == DefaultManager.DBReturnCode.SUCCESS)
{
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
if (objGlobalDefault.IsUser == true)
{
//return "{\"Session\":\"1\",\"retCode\":\"1\",\"roleID\":\"Admin\"}";
return("{\"Session\":\"1\",\"retCode\":\"1\"}");
}
else
{
//return "{\"Session\":\"1\",\"retCode\":\"0\",\"roleID\":\"Null\"}";
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
else
{
//return "{\"Session\":\"1\",\"retCode\":\"0\",\"roleID\":\"Null\"}";
return("{\"Session\":\"1\",\"retCode\":\"0\"}");
}
}
public static DBReturnCode AllState(out DataTable dtResult)
{
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_StatesLoadAll", out dtResult);
return(retCode);
}
public static DBReturnCode MyUser(out DataTable dtResult)
{
DefaultManager.DBReturnCode retCode = DefaultManager.GetDataTable("Proc_UserMasterLoadByEmail", out dtResult);
return(retCode);
}