public ActionResult DeleteConfirmed(string id)
{
tbl_client tbl_client = db.tbl_client.Find(id);
db.tbl_client.Remove(tbl_client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "client_name,contact_person,phone,email,consumer_email,claim_email,fax,add_1,add_2,city,province,country,zip")] tbl_client tbl_client)
{
if (ModelState.IsValid)
{
db.Entry(tbl_client).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_client));
}
// GET: tbl_client/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_client tbl_client = db.tbl_client.Find(id);
if (tbl_client == null)
{
return(HttpNotFound());
}
return(View(tbl_client));
}
public ActionResult Client_Edit(Int32 client_id)
{
using (jugglecontext dbcon = new jugglecontext())
{
jugglecontext dbcon1 = new jugglecontext();
int userid = Convert.ToInt32(Session["User_Id"]);
var attribute = from p in dbcon.tbl_attribute_data
where p.user_id == userid
select new { p.attribute_id, p.attribute_name };
var getmultipledata = (from a in dbcon.tbl_client
where a.client_id == client_id
select a).ToList();
string multipleattribute = getmultipledata[0].attribute_id.ToString();
tbl_client client = dbcon.tbl_client.Where(x => x.client_id == client_id).FirstOrDefault();
tbl_client client_info = new tbl_client();
client_info.client_id = client.client_id;
client_info.client_firstname = client.client_firstname;
client_info.client_lastname = client.client_lastname;
client_info.client_companyname = client.client_companyname;
client_info.client_secondaryname = client.client_secondaryname;
client_info.client_email = client.client_email;
client_info.client_code = client.client_code;
client_info.client_contact_info = client.client_contact_info;
client_info.client_address = client.client_address;
client_info.client_note = client.client_note;
client_info.x_lat = client.x_lat;
client_info.y_long = client.y_long;
client_info.created_date = client.created_date;
client_info.updated_date = DateTime.Now;
client_info.x_lat = client.x_lat;
client_info.y_long = client.y_long;
client_info.attribute_id = client.attribute_id;
client.attribute_id = client.attribute_id;
var attri = attribute.ToList().Select(c => new SelectListItem
{
Text = c.attribute_name.ToString(),
Value = c.attribute_id.ToString(),
}).ToList();
ViewBag.attributelist = attri;
return(View(client));
}
}
public ActionResult Client_delete(Int32 client_id)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
if (Session["User_Id"] != null)
{
tbl_client objclient = dbcon.tbl_client.Find(client_id);
dbcon.tbl_client.Remove(objclient);
dbcon.SaveChanges();
}
return(RedirectToAction("Client", "Client"));
}
}
catch
{
return(View());
}
}
public ActionResult Create_Client(tbl_client Client)
{
if (Session["User_Id"] != null)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
var getButton = HttpContext.Request.Form["Save"];
if (getButton == "Save")
{
string multipleattribute = Request.Form["attribute_id_multiple"].ToString();
{
var getScheduleId = Request.Form["schedule_hidden"];
var x_lat = 0.0;
var y_long = 0.0;
var clientnote = string.Empty;
try
{
x_lat = Convert.ToDouble(Request.Form["x_lat"]);
}
catch
{
x_lat = 0.0;
}
try
{
y_long = Convert.ToDouble(Request.Form["y_long"]);
}
catch
{
y_long = 0.0;
}
tbl_client tblClient = new tbl_client();
tblClient.client_firstname = Client.client_firstname;
tblClient.client_lastname = Client.client_lastname;
tblClient.client_companyname = Client.client_companyname;
tblClient.client_secondaryname = Client.client_secondaryname;
tblClient.client_email = Client.client_email;
tblClient.client_code = autogenerateid();
tblClient.client_contact_info = Client.client_contact_info;
tblClient.client_address = Client.client_address;
if (!string.IsNullOrEmpty(Client.client_note))
{
tblClient.client_note = Client.client_note;
}
else
{
tblClient.client_note = "N/A";
}
tblClient.x_lat = x_lat;
tblClient.y_long = y_long;
tblClient.attribute_id = multipleattribute.ToString();
tblClient.created_date = DateTime.Now;
tblClient.user_id = Convert.ToInt32(Session["User_Id"]);
dbcon.tbl_client.Add(tblClient);
dbcon.SaveChanges();
return(RedirectToAction("Client", "Client"));
}
}
else
{
}
return(View());
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
return(View(Client));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult Client_Edit(tbl_client clientmodel)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
string multipleattribute = Request.Form["attribute_id_multiple"].ToString();
var x_lat = 0.0;
var y_long = 0.0;
var getScheduleId = 0;
try
{
x_lat = Convert.ToDouble(Request.Form["x_lat"]);
}
catch
{
x_lat = 0.0;
}
try
{
y_long = Convert.ToDouble(Request.Form["y_long"]);
}
catch
{
y_long = 0.0;
}
try
{
getScheduleId = Convert.ToInt32(Request.Form["schedule_hidden"]);
}
catch { }
tbl_client client_info = new tbl_client();
client_info.client_id = clientmodel.client_id;
client_info.client_firstname = clientmodel.client_firstname;
client_info.client_lastname = clientmodel.client_lastname;
client_info.client_companyname = clientmodel.client_companyname;
client_info.client_secondaryname = clientmodel.client_secondaryname;
client_info.client_email = clientmodel.client_email;
client_info.client_contact_info = clientmodel.client_contact_info;
client_info.client_address = clientmodel.client_address;
if (!string.IsNullOrEmpty(clientmodel.client_note))
{
client_info.client_note = clientmodel.client_note;
}
else
{
client_info.client_note = "N/A";
}
client_info.user_id = clientmodel.user_id;
client_info.updated_date = DateTime.Now;
client_info.created_date = clientmodel.created_date;
client_info.attribute_id = multipleattribute;
client_info.client_code = clientmodel.client_code;
if (x_lat == clientmodel.x_lat)
{
client_info.x_lat = clientmodel.x_lat;
}
else
{
client_info.x_lat = x_lat;
}
if (y_long == clientmodel.y_long)
{
client_info.y_long = clientmodel.y_long;
}
else
{
client_info.y_long = y_long;
}
dbcon.Entry(client_info).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Client", "Client"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public dtoResult Insert(dtoClient t)
{
var result = new dtoResult();
result.isSuccessful = true;
try
{
var entiry = new tbl_client {
clientCode = t.clientCode,
clientName = t.clientName,
clientAddress = t.clientAddress,
clientContactNumber = t.clientContactNumber,
clientContactPerson = t.clientContactPerson,
createdBy = t.createdBy,
dateCreated = t.dateCreated,
status = t.status,
branchId = t.branchId
};
DBContext.tbl_client.Add(entiry);
DBContext.SaveChanges();
t.clientId = entiry.clientId;
result.returnObj = t;
}
catch (Exception ex)
{
result.isSuccessful = false;
result.errorMsg = ex.ToString();
}
return result;
}
