public ActionResult Client_details(int?id)
{
tblClient_profile tblClient_Profile = db.tblClient_profile.Find(id);
int length = tblClient_Profile.Logo.Count();
tblClient_Profile.Logo = tblClient_Profile.Logo.Substring(tblClient_Profile.Logo.IndexOf("/"));
return(View(tblClient_Profile));
}
public ActionResult Details(int?id)
{
id = Convert.ToInt32(Session["id"]);
tblClient_profile tblClient_Profile = db.tblClient_profile.Find(id);
int length = tblClient_Profile.Logo.Count();
tblClient_Profile.Logo = tblClient_Profile.Logo.Substring(tblClient_Profile.Logo.IndexOf("/"));
return(View(tblClient_Profile));
}
public ActionResult Client_Registration(tblClient_profile client_Registration)
{
string connection = ConfigurationManager.ConnectionStrings["Client_Management"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
string query = "insert into tblClient_profile(Company_name,Password, Logo, Company_email, Contact_person_name, Designation, Email, Cell_1, cell_2, cell_3, City,Address) values (@Company_name, @Password, @Logo, @Company_email, @Contact_person_name, @Designation, @Email, @Cell_1, @cell_2, @cell_3, @City, @Address)";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
var pass = client_Registration.Password;
client_Registration.Password = Crypto.Hash(client_Registration.Password);
cmd.Parameters.AddWithValue("@Company_name", client_Registration.Company_name);
cmd.Parameters.AddWithValue("@Password", client_Registration.Password);
if (client_Registration.Imagefile != null)
{
string filename = Path.GetFileNameWithoutExtension(client_Registration.Imagefile.FileName);
string extension = Path.GetExtension(client_Registration.Imagefile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
client_Registration.Logo = "~/Image/" + filename;
filename = Path.Combine(Server.MapPath("~/Image/"), filename);
client_Registration.Imagefile.SaveAs(filename);
}
cmd.Parameters.AddWithValue("@Logo", client_Registration.Logo);
cmd.Parameters.AddWithValue("@Company_email", client_Registration.Company_email);
cmd.Parameters.AddWithValue("@Contact_person_name", client_Registration.Contact_person_name);
cmd.Parameters.AddWithValue("@Designation", client_Registration.Designation);
cmd.Parameters.AddWithValue("@Email", client_Registration.Email);
cmd.Parameters.AddWithValue("@Cell_1", client_Registration.Cell_1);
cmd.Parameters.AddWithValue("@Cell_2", client_Registration.cell_2);
cmd.Parameters.AddWithValue("@Cell_3", client_Registration.cell_3);
cmd.Parameters.AddWithValue("@City", client_Registration.City);
cmd.Parameters.AddWithValue("@Address", client_Registration.Address);
cmd.ExecuteNonQuery();
SendEmail(client_Registration.Company_email, pass);
message = "Registration successfully done. Account activation link " +
" has been sent to your email id:" + client_Registration.Company_email;
return(RedirectToAction("Client_list", "Client"));
}
public ActionResult Client_Registration(tblClient_profile client_Registration)
{
string connection = ConfigurationManager.ConnectionStrings["Client_Management"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
string query = "insert into tblClient_profile(Company_name,Password, Logo, Company_email, Contact_person_name, Designation, Email, Cell_1, cell_2, cell_3, City,Address) values (@Company_name, @Password, @Logo, @Company_email, @Contact_person_name, @Designation, @Email, @Cell_1, @cell_2, @cell_3, @City, @Address)";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.Parameters.AddWithValue("@Company_name", client_Registration.Company_name);
cmd.Parameters.AddWithValue("@Password", client_Registration.Password);
if (client_Registration.Imagefile != null && client_Registration.Imagefile.ContentLength > 0)
{
string filename = Path.GetFileNameWithoutExtension(client_Registration.Imagefile.FileName);
string extension = Path.GetExtension(client_Registration.Imagefile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
client_Registration.Logo = "~/Logo" + filename;
filename = Path.Combine(Server.MapPath("~/Logo"), filename);
client_Registration.Imagefile.SaveAs(filename);
}
cmd.Parameters.AddWithValue("@Logo", "~/Logo" + client_Registration.Imagefile.FileName);
cmd.Parameters.AddWithValue("@Company_email", client_Registration.Company_email);
cmd.Parameters.AddWithValue("@Contact_person_name", client_Registration.Contact_person_name);
cmd.Parameters.AddWithValue("@Designation", client_Registration.Designation);
cmd.Parameters.AddWithValue("@Email", client_Registration.Email);
cmd.Parameters.AddWithValue("@Cell_1", client_Registration.Cell_1);
cmd.Parameters.AddWithValue("@Cell_2", client_Registration.cell_2);
cmd.Parameters.AddWithValue("@Cell_3", client_Registration.cell_3);
cmd.Parameters.AddWithValue("@City", client_Registration.City);
cmd.Parameters.AddWithValue("@Address", client_Registration.Address);
cmd.ExecuteNonQuery();
return(View());
}
