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 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 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);
}
//Add Household Member //
public static DBReturnCode AddHouseholdMember(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;
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string ID = objGlobalDefault.ID;
Guid UserId = new Guid(ID);
string Password = "";
using (TransactionScope objTransactionScope = new TransactionScope())
{
string PhoneNo = "";
int rowsAffected = 0;
int IsUser = 0;
int @IsDeleted = 0;
int IsApproved = 0;
SqlParameter[] SQLParams = new SqlParameter[25];
SQLParams[0] = new SqlParameter("@Email", email);
SQLParams[1] = new SqlParameter("@Password", Password);
SQLParams[2] = new SqlParameter("@FirstName", firstName);
SQLParams[3] = new SqlParameter("@LastName", lastName);
SQLParams[4] = new SqlParameter("@IsUser", IsUser);
SQLParams[5] = new SqlParameter("@City", city);
SQLParams[6] = new SqlParameter("@StateId", State);
SQLParams[7] = new SqlParameter("@userWeight1", Weight);
SQLParams[8] = new SqlParameter("@userWeight2", Weight1);
SQLParams[9] = new SqlParameter("@userLength", Length);
SQLParams[10] = new SqlParameter("@Head", Head);
SQLParams[11] = new SqlParameter("@MyRole", Role);
SQLParams[12] = new SqlParameter("@CreatedBy", UserId);
SQLParams[13] = new SqlParameter("@CreatedDate", DateTime.Now);
SQLParams[14] = new SqlParameter("@PhoneNo", PhoneNo);
SQLParams[15] = new SqlParameter("@UserName", UserId);
SQLParams[16] = new SqlParameter("@Birthday", Birth);
SQLParams[17] = new SqlParameter("@AlarmTime", DateTime.Now);
SQLParams[18] = new SqlParameter("@ParentUserId", UserId);
SQLParams[19] = new SqlParameter("@ChieldUserId", UserId);
SQLParams[20] = new SqlParameter("@UserRoleId", Role);
SQLParams[21] = new SqlParameter("@IsAccountContributor", AC);
SQLParams[22] = new SqlParameter("@IsApproved", IsApproved);
SQLParams[23] = new SqlParameter("@DisplayName", firstName + " " + lastName);
SQLParams[24] = new SqlParameter("@IsDeleted", IsDeleted);
retCode = DefaultManager.ExecuteNonQuery("Proc_UserMasterInsertByHouseholdMember", out rowsAffected, SQLParams);
if (retCode == DefaultManager.DBReturnCode.SUCCESS)
{
objTransactionScope.Complete();
}
else
{
objTransactionScope.Dispose();
}
}
return(retCode);
}
public string CheckSession()
{
GlobalDefault objGlobalDefault = (GlobalDefault)HttpContext.Current.Session["LoginUser"];
string UserId = objGlobalDefault.ID;
if (UserId != null)
{
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);
}
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 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 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;
}
