// [Fact]
public void GiveEpicComeback()
{
NpgsqlConnection _connection = new NpgsqlConnection(connString);
_connection.Open();
IHabitRepository repo = new PostgresHabitRepository(_connection, null);
Guid id = new Guid("41684bad-554b-4194-8fc2-d192273b9aa8");
Guid userID = new Guid("e28c8034-f90d-48aa-8e55-2aad1282f3bd");
Habit habit = repo.FindHabitByID(id, userID);
DateTime now = DateTime.Now;
habit.DoHabit(now);
repo.DoHabit(habit, now);
for (int i = 10; i < 20; i++)
{
now = DateTime.Now.AddDays(i);
habit.DoHabit(now);
repo.DoHabit(habit, now);
}
Habit habit2 = repo.FindHabitByID(id, userID);
_connection.Close();
HabitLogMemento hm = (HabitLogMemento)habit2.HabitLog.GetMemento();
// Habit habit2 = repo.FindHabitByID(id, userID);
// Badge badge = bRepo.FindByUserID(userID);
// Assert.Equal("Dominating", badge.Name);
_connection.Close();
}
public static void LogBeforeSave(Habit habit, TypeUpdate typeUpdate, HabitField field, object newValue, string logDescription, MSSQLLocalDBEntities context)
{
var habitLog = new HabitLog
{
ChangeDescription = logDescription,
DoneDate = DateTime.Now,
HabitId = habit.Id
};
switch (field)
{
case HabitField.Name:
habitLog.OldValue = habit.Name;
break;
case HabitField.DoneDate:
habitLog.OldValue = habit.DoneDate?.ToString();
break;
case HabitField.NewRecord:
break;
case HabitField.DeleteRecord:
break;
default:
habitLog.OldValue = "";
break;
}
habitLog.NewValue = newValue.ToString();
context.HabitLogs.Add(habitLog);
context.SaveChanges();
}
public HabitResponse GetHabitById(Guid userId, Guid habitId)
{
ValidateUserID(userId, habitId);
Habit habit = habitRepository.GetHabitById(habitId);
return(ConvertFromHabitToHabitResponse(habit));
}
public async Task UpdateHabitsAsync_WithCorrectData_ShouldReturnCorrectResult()
{
var color = new Color
{
Id = 1,
Name = "Test",
Hex = "TestHex",
};
var calendar = new Calendar
{
Id = "CalendarId",
Title = "Default",
DefaultCalendarColor = color,
DefaultCalendarColorId = color.Id,
};
var goal = new Goal
{
Id = "TestId",
Title = "Test",
Calendar = calendar,
CalendarId = calendar.Id,
IsActive = true,
Color = color,
ColorId = color.Id,
};
var habit = new Habit
{
Id = "TestId",
Title = "Test",
StartDateTime = new DateTime(2020, 02, 02, 12, 0, 0),
EndDateTime = new DateTime(2020, 02, 02, 12, 30, 0),
GoalId = goal.Id,
Goal = goal,
IsCompleted = false,
};
var currentDate = DateTime.Parse("02/02/2020");
var startEndDatetime = new StartEndDateTime
{
Start = new DateTime(2020, 02, 02, 12, 0, 0),
End = new DateTime(2020, 02, 02, 12, 30, 0),
};
this.dateTimeService
.Setup(x => x.GenerateDatesForMonthAhead(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <string>(), It.IsAny <DateTime>()))
.Returns(new List <StartEndDateTime> {
startEndDatetime
});
this.habitsRepository.Setup(x => x.All()).Returns(new List <Habit> {
habit
}.AsQueryable());
var result = await this.habitService.UpdateHabitsAsync(goal, habit.Id);
this.habitsRepository.Verify(x => x.All(), Times.Exactly(2));
this.habitsRepository.Verify(x => x.SaveChangesAsync(), Times.Exactly(2));
}
public void CreateHabit()
{
NpgsqlConnection _connection = new NpgsqlConnection(connString);
_connection.Open();
IHabitRepository repo = new PostgresHabitRepository(_connection, null);
string name = "sleep";
string[] day_off = { "Sun" };
Habit h = new Habit(name, day_off, user_id);
repo.Create(h);
Habit h2 = repo.FindById(h.ID);
Assert.NotNull(h2);
Assert.Equal(h.ID, h2.ID);
Assert.Equal(h.UserID, h2.UserID);
Assert.Equal(h.Name, h2.Name);
Assert.Equal(h.DaysOff, h2.DaysOff);
_connection.Close();
}
async Task DeleteHabit(Habit habit)
{
// TODO: sync DataService list with db list
await DataService.DeleteHabit(habit);
State.SelectedHabit = null;
}
public async Task CreateHabit(Habit habit)
{
var jsonData = JsonConvert.SerializeObject(habit);
var jsonResult = await PostDataAsync("api/habit/create", jsonData);
return;
}
public void HabitTrackTest()
{
User popo = User.NewUser("Popo");
List <Habit> list = new List <Habit>();
Habit habit = Habit.addNewHabit(popo.ID, "Belajar", new string[] { "Tue", "Wed" });
Habit habit2 = Habit.addNewHabit(popo.ID, "Mandi", new string[] { "Mon" });
list.Add(habit);
list.Add(habit2);
string name = null;
foreach (var i in list)
{
if (i.Name == habit.Name)
{
name = i.Name;
break;
}
}
Assert.NotNull(list);
Assert.Equal(name, habit.Name);
}
public async Task <ActionResult <Habit> > CreateHabit(Habit habit)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Something wrong with the model!"));
}
_repository.Add <Habit>(habit);
if (await _repository.SaveChangesAsync())
{
return(Ok());
}
else
{
return(BadRequest("Something bad happened!"));
}
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message));
}
}
public List <Habit> FindByUserId(Guid user_id)
{
List <Habit> _list = new List <Habit>();
string query = @"select id, name, user_id, CAST(days_off as text) from ""habit"" where user_id = @user_id and deleted_at is null";
using (var cmd = new NpgsqlCommand(query, _connection, _transaction))
{
cmd.Parameters.AddWithValue("user_id", user_id);
using (NpgsqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Guid id = reader.GetGuid(0);
string name = reader.GetString(1);
Guid _user_id = reader.GetGuid(2);
string daysoff = reader.GetString(3);
string[] dday = daysoff.Split(new Char[] { '{', '}', '"', ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int index = 0; index < dday.Length; index++)
{
dday[index] = dday[index].Trim();
}
Habit h = new Habit(id, _user_id, name, dday, new Logs());
_list.Add(h);
}
}
return(_list);
}
}
public HttpResponseMessage CreateHabit(Habit habit)
{
MySqlConnection conn = new MySqlConnection(CONNECTION_STRING);
try
{
conn.Open();
string rtn = "create_habit_procedure";
MySqlCommand cmd = new MySqlCommand(rtn, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", habit.ID.ToString());
cmd.Parameters.AddWithValue("@description", habit.Description);
cmd.Parameters.AddWithValue("@difficulty", habit.Difficulty.ToString());
cmd.Parameters.AddWithValue("@username", habit.Username);
cmd.ExecuteNonQuery();
return(base.BuildSuccessResult(HttpStatusCode.OK));
}
catch (Exception)
{
return(base.BuildErrorResult(HttpStatusCode.BadRequest, "Error creating habit!"));
}
finally
{
conn.Close();
}
}
public ActionResult <Habits> AddNewHabit(Guid userID, [FromBody] RequestData data)
{
NpgsqlConnection _connection = new NpgsqlConnection(connString);
_connection.Open();
IHabitRepository repo1 = new HabitRepository(_connection, null);
IGainer logGainer = new LogSuccess();
try
{
Habit h = HabitFactory.Create(data.Name, data.days, userID, logGainer);
repo1.CreateHabit(h, data.days);
repo1.AddLog(h.ID);
repo1.AddStreak(h.ID, h.getStreak());
return(new Habits()
{
ID = h.ID,
name = h.name,
user_id = h.users,
Log_count = h.Logs,
days = h.daysoff,
current_streak = h.current_streak,
longest_streak = h.longest_streak
});
}
catch
{
return(NotFound("user not found"));
}
}
public void CheckHabit2()
{
Guid habit_id = Guid.NewGuid();
Guid user_id = Guid.NewGuid();
DateTime now = DateTime.Now;
Days[] dayoff = new Days[] { new Days("Mon"), new Days("Sun") };
Habit h = new Habit(habit_id, "Nyanyi", dayoff, user_id, now);
h.DoHabit(DateTime.Now.AddDays(0)); //Sun
// h.DoHabit(DateTime.Now.AddDays(1)); //Mon
h.DoHabit(DateTime.Now.AddDays(3)); //Wed
h.DoHabit(DateTime.Now.AddDays(4)); //Thu
h.DoHabit(DateTime.Now.AddDays(6)); //Sun
h.DoHabit(DateTime.Now.AddDays(7)); //Sun
HabitLogMemento hm = (HabitLogMemento)h.HabitLog.GetMemento();
Assert.Equal(2, hm.longest_streak);
Assert.Equal(2, hm.current_streak);
Assert.Equal(5, hm.log_count);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Date,DailyHabit,Intention,Feedback")] Habit habit)
{
if (id != habit.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(habit);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HabitExists(habit.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(habit));
}
public ActionResult <Habits> Log(Guid userID, Guid id)
{
NpgsqlConnection _connection = new NpgsqlConnection(connString);
_connection.Open();
IHabitRepository repo1 = new HabitRepository(_connection, null);
try
{
Habit h = repo1.FindByID(id, userID);
repo1.AddLog(id);
Habit habit = HabitFactory.AddLog(h);
_connection.Close();
return(new Habits()
{
ID = habit.ID,
name = habit.name,
user_id = habit.users,
days = habit.daysoff,
Log_count = habit.Logs,
current_streak = habit.current_streak,
longest_streak = habit.longest_streak
});
}
catch
{
return(NotFound("Failed"));
}
}
public void NotDaysOff()
{
string[] days_off = { "Sun", "Sat", "tue", "Wed", "Thu", "Fri" };
Exception ex = Assert.Throws <Exception>(() => h = new Habit(name, days_off));
Assert.Equal("Make sure the days off are same format and not duplicate", ex.Message);
}
public void HabitLength()
{
string[] days_off = { "Sun", "Tue", "Wed", "Thu", "Fri", "Sat" };
Exception ex = Assert.Throws <Exception>(() => h = new Habit("a", days_off));
Assert.Equal("name length must between 2 to 100", ex.Message);
}
private List <DayViewModel> GetLastWeek(Habit habit)
{
var days = new List <DayViewModel>();
var lastweek = habit.DayStatuses.Where(d => d.StatusDate.Date > DateTime.Now.Date.AddDays(-7)).OrderByDescending(d => d.StatusDate);
foreach (var date in lastweek)
{
DayViewModel day = new DayViewModel();
day.DayStatus = date.Status.StatusName;
day.DayId = date.DayStatusId;
day.Date = date.StatusDate;
day.HasNote = (date.NoteHeadline != null && date.NoteHeadline != "") || (date.Note != null && date.Note != "");
day.WithDay = true;
days.Add(day);
}
if (days.Count < 7)
{
int disabled = 7 - days.Count;
for (int i = 0; i < disabled; i++)
{
DayViewModel day = new DayViewModel();
day.DayStatus = "disabled";
day.WithDay = true;
days.Add(day);
}
}
days.Reverse();
return(days);
}
private Habit CreateHabit()
{
var realmDb = Realm.GetInstance();
var habits = realmDb.All <Habit>().ToList();
var maxHabitId = 0;
if (habits.Count != 0)
{
maxHabitId = habits.Max(h => h.Id);
}
Habit habit = new Habit()
{
Id = maxHabitId + 1,
TaskTitle = TaskTitle,
Notes = Notes,
PositiveSelected = PositiveSelected,
NegativeSelected = NegativeSelected,
Difficulty = SelectedDifficulty,
ResetStreak = SelectedResetStreak
};
realmDb.Write(() =>
{
realmDb.Add(habit);
});
return(habit);
}
public async Task <IActionResult> Put(int id, [FromBody] HabitModel habitModel)
{
RepeatDays?result = null;
if (habitModel.RepeatDays != null)
{
RepeatDays[] repeatDays = habitModel.RepeatDays.Select(o => (RepeatDays)o).ToArray();
foreach (RepeatDays f in repeatDays)
{
result |= (RepeatDays)f;
}
if (habitModel.Repeat == null || habitModel.Repeat != Repeat.Weekly)
{
result = null;
}
}
Habit habit = new Habit
{
Id = habitModel.Id,
Name = habitModel.Name,
Description = habitModel.Description,
StartDate = habitModel.StartDate == null?dateTimeService.GetCurrentDateTime() : (DateTime)habitModel.StartDate,
EndDate = habitModel.EndDate,
Repeat = habitModel.Repeat == null ? Repeat.NoRepeat : (Repeat)habitModel.Repeat,
RepeatDays = (RepeatDays?)result,
Colour = habitModel.Colour,
Mesurable = habitModel.Mesurable,
NumberOfBlocks = habitModel.NumberOfBlocks,
RepresentationOfBlocks = habitModel.RepresentationOfBlocks
};
habitService.UpdateHabit(id, habit);
return(NoContent());
}
public async Task <IActionResult> Edit(Guid id, [Bind("Id,Name,HabitDays,HabitTimeNotification")] Habit habit)
{
if (id != habit.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(habit);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HabitExists(habit.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(habit));
}
public async Task <IActionResult> Post([FromBody] HabitModel habitModel)
{
RepeatDays[] repeatDays = habitModel.RepeatDays.Select(o => (RepeatDays)o).ToArray();
RepeatDays? result = null;
foreach (RepeatDays f in repeatDays)
{
result |= (RepeatDays)f;
}
if (habitModel.Repeat == null || habitModel.Repeat != Repeat.Weekly)
{
result = null;
}
Habit habit = new Habit
{
Id = habitModel.Id,
Name = habitModel.Name,
Description = habitModel.Description,
StartDate = habitModel.StartDate == null?dateTimeService.GetCurrentDateTime() : (DateTime)habitModel.StartDate,
EndDate = habitModel.EndDate,
Repeat = habitModel.Repeat == null? Repeat.NoRepeat :(Repeat)habitModel.Repeat,
RepeatDays = (RepeatDays?)result,
Colour = habitModel.Colour,
Mesurable = habitModel.Mesurable,
NumberOfBlocks = habitModel.NumberOfBlocks,
RepresentationOfBlocks = habitModel.RepresentationOfBlocks
};
return(CreatedAtAction("Get", new { id = habit.Id }, habitService.AddHabit(habit)));
}
public HttpResponseMessage postHabit(Guid user_id, Guid id)
{
try
{
var result = new HttpResponseMessage(HttpStatusCode.OK);
var habit = habitDatabaseEntities.Habit.Find(id);
if (habit.user_id == user_id)
{
var j = Repo.habitRepo.habitRegister(habit.name, habit.days_off, user_id);
}
var h = new Habit();
h.current_streak++;
if (h.current_streak == 5)
{
// habitDatabaseEntities.Badges.Add();
}
h.log_count++;
h.logs = String.Concat(h.logs, ", " + DateTime.Now.ToString());
return(result);
}
catch
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest));
}
}
private Notification CreateForNotifyFinishHabit(Habit habit, string nextHabitName)
{
var context = Application.Context;
string title = $"{habit.Name} 완료";
string message = $"다음 습관 {nextHabitName}을 시작해주세요~";
if (nextHabitName == "더 수행할 습관이 없습니다.")
{
message = nextHabitName;
}
Android.Net.Uri alarmSound = RingtoneManager.GetDefaultUri(RingtoneType.Notification);
var fileName = habit.Image.Replace(".png", string.Empty);
var imageId = context.Resources.GetIdentifier(fileName, "drawable", context.PackageName);
var notificationBuilder = new NotificationCompat.Builder(context, NOTIFICATION_CHANNEL_ID);
var notification = notificationBuilder.SetOngoing(false)
.SetSmallIcon(imageId)
.SetContentTitle(title)
.SetContentText(message)
.SetPriority((int)NotificationImportance.High)
.SetVisibility(NotificationCompat.VisibilityPublic)
.SetSound(alarmSound)
.SetVibrate(vibrationPattern)
.SetContentIntent(OpenAppIntent())
.SetAutoCancel(true)
.Build();
return(notification);
}
// GET: Habit
public ActionResult Index(int habitId)
{
Habit dbHabit = db.Habits.First(h => h.HabitId == habitId);
var habitModel = new HabitViewModel(dbHabit);
return(View(habitModel));
}
public async Task <bool> GenerateHabitsAsync(Goal goal, DateTime currentDate)
{
if (goal == null)
{
throw new ArgumentException(InvalidGoalModelErrorMessage);
}
var startEndDateTimes = this.dateTimeService.GenerateDatesForMonthAhead((int)goal.Duration, (int)goal.Frequency, goal.DayTime.ToString(), currentDate);
foreach (var time in startEndDateTimes)
{
var habit = new Habit()
{
Title = goal.Title,
StartDateTime = time.Start,
EndDateTime = time.End,
Goal = goal,
};
await this.habitRepository.AddAsync(habit);
}
var result = await this.habitRepository.SaveChangesAsync();
return(result > 0);
}
public async Task <IActionResult> PutHabit(int id, Habit habit)
{
if (id != habit.Id)
{
return(BadRequest());
}
_context.Entry(habit).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HabitExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult <Habits> UpdateHabit(Guid userID, Guid id, [FromBody] RequestData data)
{
try
{
NpgsqlConnection _connection = new NpgsqlConnection(connString);
_connection.Open();
IHabitRepository repo1 = new HabitRepository(_connection, null);
Habit h = HabitFactory.Update(id, userID, data.Name, data.days);
repo1.UpdateHabit(h.ID, h.users, h.name, data.days);
return(new Habits()
{
ID = h.ID,
name = h.name,
user_id = h.users,
Log_count = h.Logs,
days = h.daysoff,
current_streak = h.current_streak,
longest_streak = h.longest_streak
});
}
catch
{
return(NotFound("error"));
}
}
public void Holiday()
{
string[] days_off = { "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat" };
Exception ex = Assert.Throws <Exception>(() => h = new Habit(name, days_off));
Assert.Equal("Days off may not be as many as 7", ex.Message);
}
public ActionResult <Habits> DeleteHabit(Guid userID, Guid id)
{
NpgsqlConnection _connection = new NpgsqlConnection(connString);
_connection.Open();
IHabitRepository repo1 = new HabitRepository(_connection, null);
try
{
Habit h = repo1.FindByID(id, userID);
repo1.DeleteHabit(id, userID);
return(new Habits()
{
ID = h.ID,
name = h.name,
user_id = h.users,
days = h.daysoff,
Log_count = h.Logs,
current_streak = h.current_streak,
longest_streak = h.longest_streak
});
}
catch
{
return(NotFound("Failed!"));
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
//SqlTransaction Transaction;
//con.Open();
//Transaction = con.BeginTransaction();
/* try
{
new SqlCommand("INSERT INTO Transact VALUES ('" +
* Convert.ToString(Session["Sessionname"]) + "','" +
* Convert.ToString(Session["SessionDOB"]) + "','" +
* Convert.ToString(Session["SessionGender"]) + "','" +
* Convert.ToString(Session["SessionMobile"]) + "','" +
* Convert.ToString(Session["SessionCountry"]) + "','" +
* DDL_State.SelectedItem + "','" + DDL_City.SelectedItem + "','" +
* Convert.ToString(Session["SessionReligion"]) + "','" +
* Convert.ToString(Session["SessionCaste"]) + "','" +
* DDL_SubCaste.SelectedItem + "','" + Txt_Gothram.Text + "','" +
* Convert.ToString(Session["SessionEmail"]) + "','" + Rbtn_PhysicalStatus.SelectedValue + "','" +
* Txt_Desc.Text + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("INSERT INTO EduDetails values ('" + Txt_Height.Text + "','" + DDL_Occupation.SelectedItem + "','" + Rbtn_EmpIn.SelectedValue + "','" + Rbtn_IncomeType.SelectedValue + "','" + DDL_IncomeType.SelectedItem + "','" + Txt_Amount.Text + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("INSERT INTO Habit values('" + Rbtn_Food.SelectedValue + "','" + Rbtn_Smoking.SelectedValue + "','" + Rbtn_Drinking.SelectedValue + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("INSERT INTO AstrologicalInfo values('" + Rbtn_Dhosam.SelectedValue + "','" + DDL_Star.SelectedItem + "','" + DDL_Moon.SelectedItem + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("insert into Family values('" + Rbtn_familystatus.SelectedValue + "','" + Rbtn_FamType.SelectedValue + "','" + Rbtn_FamValue.SelectedValue + "');", con, Transaction).ExecuteNonQuery();
Transaction.Commit();
}
catch
{
Transaction.Rollback();
}
con.Close();*/
using (TransactionScope ts = new TransactionScope())
{
try
{
//using (DataContext contextObject = new DataContext(ConnectionString))
//{
// Open the contextObject connection state explicitly
ObjEntity.Connection.Open();
string hh = Session["SessionDOB"].ToString();
// //First SaveChange method.
MatrimonyDetail objMatrim = new MatrimonyDetail();
objMatrim.MatrimonyID = 1;
objMatrim.Name = Convert.ToString(Session["Sessionname"]);
objMatrim.DOB = DateTime.Parse(hh);
objMatrim.Gender = Convert.ToString(Session["SessionGender"]);
objMatrim.CountryID = int.Parse(Session["SessionCountry"].ToString());
objMatrim.MobileNo = Convert.ToString(Session["SessionMobile"]);
objMatrim.StateID = int.Parse(DDL_State.SelectedValue);
objMatrim.CityID = int.Parse(DDL_City.SelectedValue);
objMatrim.ReligionID = int.Parse(Session["SessionReligion"].ToString());
objMatrim.CasteID = int.Parse(Session["SessionCaste"].ToString());
objMatrim.SubCasteID = 6;
//objMatrim.SubCasteID = int.Parse(DDL_SubCaste.SelectedValue);
objMatrim.GothraID = 1;
objMatrim.Email = Convert.ToString(Session["SessionEmail"]);
objMatrim.LoginPwd = Convert.ToString(Session["SessionPwd"]);
string strMaritalStatus = "U";
if (Rbtn_MartialStatus1.Checked == true)
strMaritalStatus = "U";
else if (Rbtn_MartialStatus2.Checked == true)
strMaritalStatus = "M";
else if (Rbtn_MartialStatus3.Checked == true)
strMaritalStatus = "D";
else if (Rbtn_MartialStatus4.Checked == true)
strMaritalStatus = "A";
objMatrim.MaritalStatus = strMaritalStatus;
//objMatrim.TongueID = int.Parse(Session["SessionMotherTon"].ToString());
//objMatrim.NoOfChild = DDL_NoOfChild.SelectedValue.ToString();
objMatrim.NoOfChild = "on";
if (Rbtn_ChildLiving1.Checked == true)
objMatrim.LivingWith = "Y";
else
objMatrim.LivingWith = "N";
objMatrim.DescriptionInfo = Txt_Desc.Text;
objMatrim.ActiveInd = "N";
objMatrim.CreatedDate = System.DateTime.Now;
objMatrim.UpdatedDate = System.DateTime.Now;
ObjEntity.AddToMatrimonyDetails(objMatrim);
ObjEntity.SaveChanges();
PhysicalAttr Objphysical = new PhysicalAttr();
Objphysical.MatrimonyID = 1;
Objphysical.HeightAttr = Convert.ToInt32(Txt_Height.Text);
Objphysical.WeightAttr = Convert.ToInt32(Txt_Weight.Text);
string ObjBodytype = "Average";
if (Rbtn_BodyType1.Checked == true)
ObjBodytype = "Average";
else if (Rbtn_BodyType2.Checked == true)
ObjBodytype = "Athletic";
else if (Rbtn_BodyType3.Checked == true)
ObjBodytype = "Slim";
else if (Rbtn_BodyType4.Checked == true)
ObjBodytype = "Heavy";
Objphysical.BodyType = ObjBodytype;
string ObjComplexion = "Fair";
if (Rbtn_Complextion1.Checked == true)
ObjComplexion = "Fair";
else if (Rbtn_Complextion2.Checked == true)
ObjComplexion = "Very Fair";
else if (Rbtn_Complextion3.Checked == true)
ObjComplexion = "Wheatish";
else if (Rbtn_Complextion4.Checked == true)
ObjComplexion = "Wheatish-Brown";
else if (Rbtn_Complextion5.Checked == true)
ObjComplexion = "Dark";
Objphysical.Complexion = ObjComplexion;
string ObjPhyStatus = "Normal";
if (Rbtn_PhysicalStatus1.Checked == true)
ObjPhyStatus = "Normal";
else if (Rbtn_PhysicalStatus2.Checked == true)
ObjPhyStatus = "Physical Status";
Objphysical.PhysicalStatus = ObjPhyStatus;
ObjEntity.AddToPhysicalAttrs(Objphysical);
ObjEntity.SaveChanges();
EduDetail ObjEduDetail = new EduDetail();
ObjEduDetail.MatrimonyID=1;
ObjEduDetail.EducationID=int.Parse(DDL_HighestEdu.SelectedValue);
ObjEduDetail.OccupID=int.Parse(DDL_Occupation.SelectedValue);
String objemployedIn="Goverment";
if (Rbtn_EmpIn1.Checked == true)
objemployedIn="Goverment";
else if (Rbtn_EmpIn2.Checked == true)
objemployedIn="Private";
else if (Rbtn_EmpIn3.Checked == true)
objemployedIn="Business";
else if (Rbtn_EmpIn4.Checked == true)
objemployedIn="Self-Employed";
else if (Rbtn_EmpIn5.Checked == true)
objemployedIn="Defence";
ObjEduDetail.EmployedIn=objemployedIn;
string objIncometype="Monthly Income";
if (Rbtn_IncomeType1.Checked == true)
objIncometype="Monthly Income";
else if (Rbtn_IncomeType2.Checked == true)
objIncometype="Annual Income";
ObjEduDetail.IncomeType=objIncometype;
ObjEduDetail.CurrID=int.Parse(DDL_IncomeType.SelectedValue);
ObjEduDetail.Income = Convert.ToInt32(Txt_Amount.Text);
ObjEntity.AddToEduDetails(ObjEduDetail);
ObjEntity.SaveChanges();
Habit objhabits = new Habit();
objhabits.MatrimonyID = 1;
string ObjFoodtype = "Non-Vegetarian";
if (Rbtn_FoodType1.Checked == true)
ObjFoodtype = "Non-Vegetarian";
else if (Rbtn_FoodType2.Checked == true)
ObjFoodtype = "Vegetarian";
else if (Rbtn_FoodType3.Checked == true)
ObjFoodtype = "Eggetarian";
objhabits.Food = ObjFoodtype;
string objSmoking = "No";
if (Rbtn_Smoking1.Checked == true)
objSmoking = "No";
else if (Rbtn_Smoking2.Checked == true)
objSmoking = "Yes";
else if (Rbtn_Smoking3.Checked == true)
objSmoking = "Occasionally";
objhabits.Smoking = objSmoking;
string objDrinking = "No";
if (Rbtn_Drinking1.Checked == true)
objDrinking = "No";
else if (Rbtn_Drinking2.Checked == true)
objDrinking = "Yes";
else if (Rbtn_Drinking3.Checked == true)
objDrinking = "Occasionally";
objhabits.Drinking = objDrinking;
ObjEntity.AddToHabits(objhabits);
ObjEntity.SaveChanges();
AstrologicalInfo objastrological = new AstrologicalInfo();
objastrological.MatrimonyID = 1;
string objdosham="No";
if (Rbtn_Chevvai1.Checked == true)
objdosham="No";
else if (Rbtn_Chevvai2.Checked == true)
objdosham="Yes";
else if (Rbtn_Chevvai3.Checked == true)
objdosham="Dont Know";
objastrological.Dosham = objdosham;
objastrological.StarID = int.Parse(DDL_Star.SelectedValue);
objastrological.RaasiID = int.Parse(DDL_Moon.SelectedValue);
ObjEntity.AddToAstrologicalInfoes(objastrological);
ObjEntity.SaveChanges();
Family objfamily = new Family();
objfamily.MatrimonyID = 1;
string ObjFamilystatus = "Middle Class";
if (Rbtn_FamilyStatus1.Checked == true)
ObjFamilystatus = "Middle Class";
else if (Rbtn_FamilyStatus2.Checked == true)
ObjFamilystatus = "Upper-Middle Class";
else if (Rbtn_FamilyStatus3.Checked == true)
ObjFamilystatus = "Rich";
else if (Rbtn_FamilyStatus4.Checked == true)
ObjFamilystatus = "Affluent";
objfamily.FamilyStatus = ObjFamilystatus;
string ObjFamilyType = "Single";
if (Rbtn_FamilyType1.Checked == true)
ObjFamilystatus = "Single";
else if (Rbtn_FamilyType2.Checked == true)
ObjFamilystatus = "Nuclear";
objfamily.FamilyType = ObjFamilyType;
string ObjFamilyValue = "Orthodox";
if (Rbtn_FamilyValue1.Checked == true)
ObjFamilyValue = "Orthodox";
else if (Rbtn_FamilyValue2.Checked == true)
ObjFamilyValue = "Traditional";
else if (Rbtn_FamilyValue3.Checked == true)
ObjFamilyValue = "Moderate";
else if (Rbtn_FamilyValue4.Checked == true)
ObjFamilyValue = "Liberal";
objfamily.FamilyValues = ObjFamilyValue;
ObjEntity.AddToFamilies(objfamily);
ObjEntity.SaveChanges();
//// Second SaveChange method.
//....Codes for 2nd table.....
//contextObject.SaveChanges();
//// Third SaveChange method.
//....Codes for 3rd table.....
//contextObject.SaveChanges();
// If execution reaches here, it indicates the successfull completion of all three save operation. hence comit the transaction.
ts.Complete();
//}
}
catch (Exception ex)
{
// If any excption is caught, roll back the entire transaction and ends the transaction scope
ts.Dispose();
}
finally
{
// Close the opened connection
if (ObjEntity.Connection.State == ConnectionState.Open)
{
ObjEntity.Connection.Close();
}
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
//using (DataContext contextObject = new DataContext(ConnectionString))
//{
// Open the contextObject connection state explicitly
ObjEntity.Connection.Open();
string hh = Session["SessionDOB"].ToString();
//First SaveChange method.
MatrimonyDetail objMatrim = new MatrimonyDetail();
int? intldt = ObjEntity.MatrimonyDetails.Max(u => (int?)u.MatrimonyID);
if (intldt == null)
{
objMatrim.MatrimonyID = 1;
}
else
{
int intldt2 = ObjEntity.MatrimonyDetails.Max(u => u.MatrimonyID);
objMatrim.MatrimonyID = intldt2 + 1;
}
objMatrim.ProfileFor = Convert.ToString(Session["ProfileFor"]);
objMatrim.Name = Convert.ToString(Session["Sessionname"]);
objMatrim.DOB = DateTime.Parse(hh);
objMatrim.Gender = Convert.ToString(Session["SessionGender"]);
objMatrim.CountryID = int.Parse(Session["SessionCountry"].ToString());
objMatrim.MobileNo = Convert.ToString(Session["SessionMobile"]);
if (blnNoStateCity)
{
objMatrim.StateID = 999;
objMatrim.CityID = 999;
objMatrim.StateName = TxtState.Text.Trim();
objMatrim.CityName = TxtCity.Text.Trim();
}
else
{
objMatrim.StateID = int.Parse(DDL_State.SelectedValue);
objMatrim.CityID = int.Parse(DDL_City.SelectedValue);
objMatrim.StateName = Convert.ToString(DDL_State.SelectedItem);
objMatrim.CityName = "";
}
objMatrim.ReligionID = int.Parse(Session["SessionReligion"].ToString());
objMatrim.CasteID = int.Parse(Session["SessionCaste"].ToString());
//objMatrim.SubCasteID = 4;
//objMatrim.SubCasteID = int.Parse(DDL_SubCaste.SelectedValue);
if (blnNoSubCaste)
{
objMatrim.SubCasteID = 999;
objMatrim.SubcasteName = Txt_SubCaste.Text.Trim();
}
else
{
objMatrim.SubCasteID = int.Parse(DDL_SubCaste.SelectedValue);
objMatrim.SubcasteName = "";
}
//objMatrim.GothraID = 1;
if (blnNoSubCaste)
{
objMatrim.GothraID = 999;
objMatrim.GothraName = Txt_Gothram.Text.Trim();
}
else
{
objMatrim.GothraID = int.Parse(DDl_Gothra.SelectedValue);
objMatrim.GothraName = "";
}
objMatrim.Email = Convert.ToString(Session["SessionEmail"]);
objMatrim.LoginPwd = Convert.ToString(Session["SessionPwd"]);
string strMaritalStatus = "U";
if (Rbtn_MartialStatus1.Checked == true)
strMaritalStatus = "U";
else if (Rbtn_MartialStatus2.Checked == true)
strMaritalStatus = "W";
else if (Rbtn_MartialStatus3.Checked == true)
strMaritalStatus = "D";
else if (Rbtn_MartialStatus4.Checked == true)
strMaritalStatus = "A";
objMatrim.MaritalStatus = strMaritalStatus;
//objMatrim.TongueID = int.Parse(Session["SessionMotherTon"].ToString());
//objMatrim.NoOfChild = DDL_NoOfChild.SelectedValue.ToString();
objMatrim.NoOfChild = DDL_NoOfChild.SelectedValue.ToString();
if (Rbtn_ChildLiving1.Checked == true)
objMatrim.LivingWith = "Y";
else
objMatrim.LivingWith = "N";
if (Rbtn_Caste1.Checked == true)
objMatrim.SameCommunity = "Y";
else
objMatrim.SameCommunity = "N";
objMatrim.DescriptionInfo = Txt_Desc.Text;
objMatrim.ActiveInd = "N";
objMatrim.CreatedDate = DateTime.Parse(System.DateTime.Now.ToString());
objMatrim.UpdatedDate = DateTime.Parse(System.DateTime.Now.ToString());
ObjEntity.AddToMatrimonyDetails(objMatrim);
ObjEntity.SaveChanges();
PhysicalAttr objphysical = new PhysicalAttr();
objphysical.MatrimonyID = objMatrim.MatrimonyID;
objphysical.HeightAttr = Convert.ToInt32(Txt_Height.Text);
objphysical.WeightAttr = Convert.ToInt32(Txt_Weight.Text);
string ObjBodytype = "A";
if (Rbtn_BodyType1.Checked == true)
ObjBodytype = "A";
else if (Rbtn_BodyType2.Checked == true)
ObjBodytype = "T";
else if (Rbtn_BodyType3.Checked == true)
ObjBodytype = "S";
else if (Rbtn_BodyType4.Checked == true)
ObjBodytype = "H";
objphysical.BodyType = ObjBodytype;
string strComplexion = "F";
if (Rbtn_Complextion1.Checked == true)
strComplexion = "F";
else if (Rbtn_Complextion2.Checked == true)
strComplexion = "V";
else if (Rbtn_Complextion3.Checked == true)
strComplexion = "W";
else if (Rbtn_Complextion4.Checked == true)
strComplexion = "B";
else if (Rbtn_Complextion5.Checked == true)
strComplexion = "D";
objphysical.Complexion = strComplexion;
string strPhyStatus = "N";
if (Rbtn_PhysicalStatus1.Checked == true)
strPhyStatus = "N";
else if (Rbtn_PhysicalStatus2.Checked == true)
strPhyStatus = "P";
objphysical.PhysicalStatus = strPhyStatus;
ObjEntity.AddToPhysicalAttrs(objphysical);
ObjEntity.SaveChanges();
EduDetail ObjEduDetail = new EduDetail();
ObjEduDetail.MatrimonyID = objMatrim.MatrimonyID;
ObjEduDetail.EducationID = int.Parse(DDL_HighestEdu.SelectedValue);
ObjEduDetail.OccupID = int.Parse(DDL_Occupation.SelectedValue);
String strEmployedIn = "G";
if (Rbtn_EmpIn1.Checked == true)
strEmployedIn = "G";
else if (Rbtn_EmpIn2.Checked == true)
strEmployedIn = "P";
else if (Rbtn_EmpIn3.Checked == true)
strEmployedIn = "B";
else if (Rbtn_EmpIn4.Checked == true)
strEmployedIn = "S";
else if (Rbtn_EmpIn5.Checked == true)
strEmployedIn = "D";
ObjEduDetail.EmployedIn = strEmployedIn;
string objIncometype = "M";
if (Rbtn_IncomeType1.Checked == true)
objIncometype = "M";
else if (Rbtn_IncomeType2.Checked == true)
objIncometype = "A";
ObjEduDetail.IncomeType = objIncometype;
ObjEduDetail.CurrID = int.Parse(DDL_IncomeType.SelectedValue);
ObjEduDetail.Income = Convert.ToInt32(Txt_Amount.Text);
ObjEntity.AddToEduDetails(ObjEduDetail);
ObjEntity.SaveChanges();
Habit objhabits = new Habit();
objhabits.MatrimonyID = objMatrim.MatrimonyID;
string ObjFoodtype = "Non-Vegetarian";
if (Rbtn_FoodType1.Checked == true)
ObjFoodtype = "N";
else if (Rbtn_FoodType2.Checked == true)
ObjFoodtype = "V";
else if (Rbtn_FoodType3.Checked == true)
ObjFoodtype = "E";
objhabits.Food = ObjFoodtype;
string objSmoking = "No";
if (Rbtn_Smoking1.Checked == true)
objSmoking = "N";
else if (Rbtn_Smoking2.Checked == true)
objSmoking = "Y";
else if (Rbtn_Smoking3.Checked == true)
objSmoking = "O";
objhabits.Smoking = objSmoking;
string objDrinking = "N";
if (Rbtn_Drinking1.Checked == true)
objDrinking = "N";
else if (Rbtn_Drinking2.Checked == true)
objDrinking = "Y";
else if (Rbtn_Drinking3.Checked == true)
objDrinking = "O";
objhabits.Drinking = objDrinking;
ObjEntity.AddToHabits(objhabits);
ObjEntity.SaveChanges();
AstrologicalInfo objastrological = new AstrologicalInfo();
objastrological.MatrimonyID = objMatrim.MatrimonyID;
string objdosham = "N";
if (Rbtn_Chevvai1.Checked == true)
objdosham = "N";
else if (Rbtn_Chevvai2.Checked == true)
objdosham = "Y";
else if (Rbtn_Chevvai3.Checked == true)
objdosham = "D";
objastrological.Dosham = objdosham;
objastrological.StarID = int.Parse(DDL_Star.SelectedValue);
objastrological.RaasiID = int.Parse(DDL_Moon.SelectedValue);
ObjEntity.AddToAstrologicalInfoes(objastrological);
ObjEntity.SaveChanges();
Family objfamily = new Family();
objfamily.MatrimonyID = objMatrim.MatrimonyID;
string ObjFamilystatus = "Middle Class";
if (Rbtn_FamilyStatus1.Checked == true)
ObjFamilystatus = "M";
else if (Rbtn_FamilyStatus2.Checked == true)
ObjFamilystatus = "U";
else if (Rbtn_FamilyStatus3.Checked == true)
ObjFamilystatus = "R";
else if (Rbtn_FamilyStatus4.Checked == true)
ObjFamilystatus = "A";
objfamily.FamilyStatus = ObjFamilystatus;
string ObjFamilyType = "S";
if (Rbtn_FamilyType1.Checked == true)
ObjFamilystatus = "S";
else if (Rbtn_FamilyType2.Checked == true)
ObjFamilystatus = "N";
objfamily.FamilyType = ObjFamilyType;
string ObjFamilyValue = "O";
if (Rbtn_FamilyValue1.Checked == true)
ObjFamilyValue = "O";
else if (Rbtn_FamilyValue2.Checked == true)
ObjFamilyValue = "T";
else if (Rbtn_FamilyValue3.Checked == true)
ObjFamilyValue = "M";
else if (Rbtn_FamilyValue4.Checked == true)
ObjFamilyValue = "L";
objfamily.FamilyValues = ObjFamilyValue;
ObjEntity.AddToFamilies(objfamily);
ObjEntity.SaveChanges();
ts.Complete();
}
catch (Exception ex)
{
// If any excption is caught, roll back the entire transaction and ends the transaction scope
ts.Dispose();
}
finally
{
// Close the opened connection
if (ObjEntity.Connection.State == ConnectionState.Open)
{
ObjEntity.Connection.Close();
Response.Redirect("Home.aspx");
}
}
}
}
