protected void btnSave_Click(object sender, EventArgs e)
{
if (IsValid())
{
using (MSIPortalContext ctx = new MSIPortalContext())
{
try
{
LU_tbl_City city = new LU_tbl_City();
var maxId = ctx.LU_tbl_City.Select(c => c.CityID).Max(); // Select Max Id
int newId = Convert.ToInt32(maxId) + 1;
string newStringId = newId.ToString("D3");
city.CityID = newStringId;
city.CityName = txtCity.Text.Trim();
city.EditUser = ((tbl_User)Session["User"]).UserID;
city.EditDate = DateTime.Now;
ctx.LU_tbl_City.Add(city);
ctx.SaveChanges();
cpSuccessMessage.Text = "City added successfully";
this.BindGrid();
cpErrorMessage.Text = string.Empty;
txtCity.Text = string.Empty;
txtCity.Focus();
MessagePanel.Visible = true;
}
catch (Exception ex)
{
}
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (IsValidUpdate())
{
using (MSIPortalContext ctx = new MSIPortalContext())
{
LU_tbl_City cityToBeUpdate = (LU_tbl_City)Session["LU_tbl_City_ToEdit"];
cityToBeUpdate.CityName = txtCityForEdit.Text;
if (((tbl_User)Session["User"]) != null)
{
cityToBeUpdate.EditUser = ((tbl_User)Session["User"]).UserID; // User
}
cityToBeUpdate.EditDate = DateTime.Now;
ctx.LU_tbl_City.Attach(cityToBeUpdate);
ctx.Entry(cityToBeUpdate).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
this.BindGrid();
TabContainer1.ActiveTabIndex = 1;
TabPanelEditCity.Visible = false;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsValid())
{
using (MSIPortalContext ctx = new MSIPortalContext())
{
try
{
LU_tbl_City city = new LU_tbl_City();
var maxId = ctx.LU_tbl_City.Select(c => c.CityID).Max(); // Select Max Id
int newId = Convert.ToInt32(maxId) + 1;
string newStringId = newId.ToString("D3");
city.CityID = newStringId;
city.CityName = txtCity.Text.Trim();
city.CountryID = ddlCountry.SelectedValue;
city.EditUser = ((tbl_User)Session["User"]).UserID;
city.EditDate = DateTime.Now;
ctx.LU_tbl_City.Add(city);
ctx.SaveChanges();
lblSuccessMessage.Text = "City added successfully";
lblErrorMessage.Text = string.Empty;
txtCity.Text = string.Empty;
ddlCountry.SelectedValue = "0";
ddlCountry.Focus();
MessagePanel.Visible = true;
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.Write("Property: {0} Error: {1}" + validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (Exception Ex)
{
}// End of
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
TabPanelEditCity.Visible = true;
TabContainer1.ActiveTabIndex = 3;
if (e.CommandName == "Modify")
{
string argument = e.CommandArgument.ToString();
using (MSIPortalContext ctx = new MSIPortalContext())
{
string cityId = argument;
//var city = from c in ctx.LU_tbl_City where c.CityName == cityId select c;
//LU_tbl_City objCity = city.ToList<LU_tbl_City>().FirstOrDefault<LU_tbl_City>();
LU_tbl_City objCity = ctx.LU_tbl_City.Where(c => c.CityID == cityId).FirstOrDefault();
Session["LU_tbl_City_ToEdit"] = objCity;
this.txtCityForEdit.Text = objCity.CityName;
TabPanelEditCity.Visible = true;
this.lblSuccessMessage.Text = string.Empty;
this.lblErrorMessage.Text = string.Empty;
}
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
//============Initialize Post Table
using (MSIPortalContext ctx = new MSIPortalContext())
{
//try
//{
tbl_Post objPost = (tbl_Post)Session["PostTobeModify"];
objPost.CategoryID = ddlCategory.SelectedValue;
objPost.CityID = ddlCommonCity.SelectedValue;
LU_tbl_City city = ctx.LU_tbl_City.Where(c => c.CityID == ddlCommonCity.SelectedValue).FirstOrDefault <LU_tbl_City>();
objPost.LU_tbl_City = city;
if (rdoCommonSales.Checked)
{
objPost.PSTID = "001";
}
else
{
objPost.PSTID = "002";
}
objPost.PostTitle = this.txtCommonPostingTitle.Text.Trim();
objPost.PostDescription = this.txtCommonPostingDescription.Text.Trim();
if (commonImageUpload.PostedFile != null && commonImageUpload.PostedFile.FileName != string.Empty)
{
commonImageUpload.SaveAs(Server.MapPath("~/imageupload/" + objPost.PostID + ".jpg"));
objPost.ImageUrl = "/imageupload/" + objPost.PostID + ".jpg";
}
//else
//{
// objPost.ImageUrl = "/Styles/images/" + "no_image.jpg";
//}
//objPost.PostingUserID = ((tbl_User)Session["User"]).UserID; // As it has benn already posted so no need to modify
objPost.ProviderFirstName = txtCommonProviderFirstName.Text.Trim();
objPost.ProviderLastName = txtCommonProviderLastName.Text.Trim();
objPost.ProviderAddress = txtCommonProviderAddress.Text.Trim();
objPost.ProviderEmail = txtCommonProviderEmil.Text.Trim();
objPost.ProviderPhoneNo = txtCommonProviderPhone.Text.Trim();
//objPost.Approved = false;
if (((tbl_User)Session["User"]) != null)
{
objPost.EditUser = ((tbl_User)Session["User"]).UserID; // User
}
objPost.EditDate = DateTime.Now;
ctx.tbl_Post.Attach(objPost);
ctx.Entry(objPost).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
////---------------After Successful Save Do the following operation
//MessagePanel.Visible = true;
//lblSuccessMessage.Visible = true;
this.BindGrid();
TabContainer1.ActiveTabIndex = 2;
TabPanelEditPost.Visible = false;
//lblUserEmailValidation.Text = string.Empty;
//this.ClearForm();
//ddlCommonCountry.Focus();
//}
//catch (DbEntityValidationException dbEx)
//{
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// Trace.Write("Property: {0} Error: {1}" + validationError.PropertyName, validationError.ErrorMessage);
// }
// }
//}
//catch (Exception Ex)
//{
//}// End of Catch
}
}
