protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
try
{
Session["ImagePath"] = "";
var fileUpload = (FileUpload)DetailsView1.FindControl("FileUpload1");
string fileToSave = String.Empty;
if (fileUpload.HasFile == true)
{
fileToSave = Server.MapPath("~/Image/" + fileUpload.FileName);
fileUpload.SaveAs(fileToSave);
}
else
{
return;
}
ObjectDataSource2.UpdateParameters["ImageFile"].DefaultValue = "~/Image/" + fileUpload.FileName;
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
TextBox txtClientId = DetailsView1.FindControl("txtClientID") as TextBox;
TextBox txtClientName = DetailsView1.FindControl("txtClientName") as TextBox;
TextBox txtClientDesc = DetailsView1.FindControl("txtClientDesc") as TextBox;
int ClientID = Convert.ToInt32(txtClientId.Text.ToString());
string ClientName = txtClientName.Text.ToString();
string ClientDesc = txtClientDesc.Text.ToString();
Debug.WriteLine("");
Debug.WriteLine("Data From Grid:");
Debug.WriteLine("EnvType ID: " + ClientID);
Debug.WriteLine("EnvType Title: " + ClientName);
Debug.WriteLine("EnvType Desc: " + ClientDesc);
DatabaseConnectivity dbcon = new DatabaseConnectivity();
int ResultQuery = dbcon.setEnvType(ClientID, ClientName, ClientDesc);
//Console.WriteLine("<script>alert(" + ResultQuery + "record has been updated." + ")</script>");
//ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery + "record has been updated." + ")</script>", true);
//ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery +")</script>", true);
DetailsView1.Visible = false;
this.Page_Load(null, null);
//UpdatePanel1.Update();
//UpdatePanel1.Update();
//DetailsView1.Style.Add("display", "none");
}
protected void btnSearchOrderNumber_Click(object sender, EventArgs e)
{
TextBox tbOrderNumber = DetailsView1.FindControl("tbOrderNumber") as TextBox;
Broker.DataAccess.Order o = Broker.DataAccess.Order.GetByOrderNumber(tbOrderNumber.Text);
TextBox tbClientEMBG = DetailsView1.FindControl("tbClientEMBG") as TextBox;
TextBox tbClientName = DetailsView1.FindControl("tbClientName") as TextBox;
TextBox tbOwnerEMBG = DetailsView1.FindControl("tbOwnerEMBG") as TextBox;
TextBox tbOwnerName = DetailsView1.FindControl("tbOwnerName") as TextBox;
if (o != null)
{
OrderID = o.ID;
ClientID = o.ClientID;
OwnerID = o.OwnerID;
tbClientEMBG.Text = o.Client.EMBG;
tbClientEMBG.ReadOnly = true;
tbClientName.Text = o.Client.Name;
tbClientName.ReadOnly = true;
tbOwnerEMBG.Text = o.Client1.EMBG;
tbOwnerEMBG.ReadOnly = true;
tbOwnerName.Text = o.Client1.Name;
tbOwnerName.ReadOnly = true;
}
else
{
tbClientEMBG.Text = string.Empty;
tbClientName.Text = string.Empty;
tbOwnerEMBG.Text = string.Empty;
tbOwnerName.Text = string.Empty;
}
}
protected void btnAddPolicyToList_Click(object sender, EventArgs e)
{
try {
TextBox tbPolicyNumberToList = (TextBox)DetailsView1.FindControl("tbPolicyNumberToList");
DropDownList ddlInsuranceCompanies = (DropDownList)DetailsView1.FindControl("ddlInsuranceCompanies");
int icID = Convert.ToInt32(ddlInsuranceCompanies.SelectedValue);
InsuranceCompany ic = InsuranceCompany.Get(icID);
PolicyItem pi = PolicyItem.GetByNumberAndInsuranceCompany(tbPolicyNumberToList.Text, icID);
if (pi != null)
{
GridView gvNewPolicies = (GridView)DetailsView1.FindControl("gvNewPolicies");
List <FactureInfo> lastFactureInfos = listFactureInfos;
FactureInfo fi = listFactureInfos.Where(c => c.PolicyNumber == tbPolicyNumberToList.Text).SingleOrDefault();
if (fi != null)
{
RegisterStartupScript("myAlert", "<script>alert('Полисата постои во листата!')</script>");
return;
}
FactureInfo newFactureInfo = new FactureInfo();
newFactureInfo.PolicyNumber = tbPolicyNumberToList.Text;
newFactureInfo.IsForFacturing = true;
newFactureInfo.ID = pi.ID;
lastFactureInfos.Add(newFactureInfo);
listFactureInfos = lastFactureInfos;
gvNewPolicies.DataSource = lastFactureInfos;
gvNewPolicies.DataBind();
}
else
{
RegisterStartupScript("myAlert", "<script>alert('Не постои полиса со избраниот број!')</script>");
}
} catch {
RegisterStartupScript("myAlert", "<script>alert('Грешка!')</script>");
}
}
protected void dsRequestDetails_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
//find the upload control
FileUpload screenCap = (FileUpload)DetailsView1.FindControl("screenCap");
//make sure there is a file
if (screenCap.HasFile)
{
//get filename
string fileName = screenCap.FileName;
//get the extension
string ext = fileName.Substring(fileName.LastIndexOf("."));
//generate a new file name
string newImageName = Guid.NewGuid().ToString();
//plug the extension back in
newImageName += ext;
//save the photo to the images folder
screenCap.SaveAs(Server.MapPath("~/screenImages/" + newImageName));
//save the photo name to the DB
e.Command.Parameters["@ReqScreenCapture"].Value = newImageName;
}
else
{
e.Command.Parameters["@ReqScreenCapture"].Value = "no_image.jpg";
//no file uploaded
}
}
protected void ddlInsuranceCompanyIndexChanged(object sender, EventArgs e)
{
DropDownList ddlInsuranceSubTypes = DetailsView1.FindControl("ddlInsuranceSubTypes") as DropDownList;
FakeBinder.SimulateBindingContext(this.Page, ddlInsuranceSubTypes);
ddlInsuranceSubTypes.DataBind();
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
string name = ((TextBox)DetailsView1.FindControl("txtName")).Text;
string image;
if (((FileUpload)DetailsView1.FindControl("fuImage")).HasFile)
{
image = ((FileUpload)DetailsView1.FindControl("fuImage")).FileName.ToString();
((FileUpload)DetailsView1.FindControl("fuImage")).SaveAs((Server.MapPath("Images/ProductImages/") + ((FileUpload)DetailsView1.FindControl("fuImage")).FileName));
}
else
{
image = "NULL";
}
double price = Convert.ToDouble(((TextBox)DetailsView1.FindControl("txtPrice")).Text);
string description = ((TextBox)DetailsView1.FindControl("txtDescription")).Text;
int idcat = Convert.ToInt32(((DropDownList)DetailsView1.FindControl("ddlCat")).SelectedIndex + 1);
int idroom = Convert.ToInt32(((DropDownList)DetailsView1.FindControl("ddlRoom")).SelectedIndex + 1);
int inventory = Convert.ToInt32(((TextBox)DetailsView1.FindControl("txtInventory")).Text);
bool featured = Convert.ToBoolean(((CheckBox)DetailsView1.FindControl("cbFeaturedEdit")).Checked);
bool taxable = Convert.ToBoolean(((CheckBox)DetailsView1.FindControl("cbTaxableEdit")).Checked);
DetailsView1.DataBind();
string query = "INSERT INTO PRODUCTS (NAME, IMAGE, PRICE, DESCRIPTION, IDCAT, IDROOM, FEATURED, TAXABLE, INVENTORY) values (@name, @image, @price, @description, @idcat, @idroom, @featured, @taxable, @inventory)";
using (SqlConnection cnn = new SqlConnection(myConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@image", image);
cmd.Parameters.AddWithValue("@price", price);
cmd.Parameters.AddWithValue("@description", description);
cmd.Parameters.AddWithValue("@idcat", idcat);
cmd.Parameters.AddWithValue("@idroom", idroom);
cmd.Parameters.AddWithValue("@featured", featured);
cmd.Parameters.AddWithValue("@taxable", taxable);
cmd.Parameters.AddWithValue("@inventory", inventory);
try
{
cnn.Open();
cmd.ExecuteNonQuery();
Response.Write("<script language='javascript'>alert('Product added to the Database.');</script>");
}
catch (SqlException ex)
{
//Response.Write("<script language='javascript'>alert('Error has occured.');</script>");
System.Diagnostics.Debug.WriteLine(ex.Message);
}
finally
{
cnn.Close();
UpdateGridView();
}
}
}
}
protected void DDLRut_PreRender(object sender, EventArgs e)
{
TextBox txtPatente = (TextBox)DetailsView1.FindControl("txtPatente");
DropDownList DDLPatente = (DropDownList)DetailsView1.FindControl("DDLPatente");
txtPatente.Text = DDLPatente.Text;
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
using (Entity entity = new Entity())
{
var goodExperience = entity.GoodExperience.Find(Convert.ToInt32(DetailsView1.DataKey.Value));
var CheckBoxList_State = ((CheckBoxList)DetailsView1.FindControl("CheckBoxList_State"));
goodExperience.State = 0;
foreach (ListItem item in CheckBoxList_State.Items)
{
if (item.Selected)
{
goodExperience.State = goodExperience.State | Convert.ToInt32(item.Value);
}
}
if (e.NewValues["OrderBy"] != null)
{
goodExperience.OrderBy = Convert.ToInt32(e.NewValues["OrderBy"]);
}
if ((goodExperience.State & 2) > 0 && (goodExperience.State & 1) > 0)
{
goodExperience.State--;
}
entity.SaveChanges();
}
Response.Redirect("GoodExperienceDetail.aspx?goodExperienceID=" + DetailsView1.DataKey.Value);
}
private void CurrentMode_Init()
{
var DropDownList_GoodGategoryID = ((DropDownList)DetailsView1.FindControl("DropDownList_GoodGategoryID"));
if (DropDownList_GoodGategoryID != null)
{
DropDownList_GoodGategoryID.DataSource = goodGategoryBLL.GetGoodGategory(o => o.State == 1).Select(o =>
new
{
Name = o.Name,
GoodGategoryID = o.GoodGategoryID
});
DropDownList_GoodGategoryID.DataBind();
if (good != null)
{
DropDownList_GoodGategoryID.SelectedValue = good.GoodGategoryID.ToString();
}
}
var HiddenField1 = (HiddenField)DetailsView1.FindControl("HiddenField1");
if (HiddenField1 != null && good != null)
{
HiddenField1.Value = good.Detail;
}
var CheckBoxList_State = ((CheckBoxList)DetailsView1.FindControl("CheckBoxList_State"));
if (CheckBoxList_State != null && good != null)
{
if ((good.State & 1) > 0)
{
CheckBoxList_State.Items[0].Selected = true;
}
if ((good.State & 2) > 0)
{
CheckBoxList_State.Items[1].Selected = true;
}
if ((good.State & 4) > 0)
{
CheckBoxList_State.Items[2].Selected = true;
}
if ((good.State & 8) > 0)
{
CheckBoxList_State.Items[3].Selected = true;
}
if ((good.State & 16) > 0)
{
CheckBoxList_State.Items[4].Selected = true;
}
if ((good.State & 32) > 0)
{
CheckBoxList_State.Items[5].Selected = true;
}
if ((good.State & 64) > 0)
{
CheckBoxList_State.Items[6].Selected = true;
}
}
}
protected void AttachmentsDetailsView_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
// Entities ctx = new Entities();
byte[] myFileBytes = null;
FileUpload myUpload = (FileUpload)DetailsView1.FindControl("FileUpload1");
// Need if not post back
if (myUpload.HasFile)
{
try
{
myFileBytes = myUpload.FileBytes;
e.Values["REQUEST_ID"] = Convert.ToDecimal(Session["ccREQUESTID"]);
e.Values["DATA"] = myFileBytes;
e.Values["FILE_NAME"] = Path.GetFileName(myUpload.PostedFile.FileName);
e.Values["DATE_ATTACHED"] = DateTime.Now;
Label3.Text = "Successfully Attached. You may attach another or select button below";
}
catch (Exception ex)
{
Label3.Text = Resources.errortestImg_001 + ex.Message.ToString();
e.Cancel = true;
}
}
else
{
Label3.Text = "You have not specified a file.";
e.Cancel = true;
}
}
protected void ObjectDataSource1_Inserting(object sender, ObjectDataSourceMethodEventArgs e)
{
try
{
Session["ImagePath"] = "";
var fileUpload1 = (FileUpload)DetailsView1.FindControl("FileUpload2");
string fileToSave = String.Empty;
if (fileUpload1.HasFile == true)
{
fileToSave = Server.MapPath("~/Image/" + fileUpload1.FileName);
fileUpload1.SaveAs(fileToSave);
}
else
{
return;
}
Session["ImagePath"] = "~/Image/" + fileUpload1.FileName;
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}
protected void ddlDocumentTypes_selectedChanged(object sender, EventArgs e)
{
TextBox tbCode = DetailsView1.FindControl("tbCode") as TextBox;
DropDownList ddlDocumentTypes = (DropDownList)sender;
tbCode.Text = CodeGenerator.DocumentSubTypeCodeGenerator(int.Parse(ddlDocumentTypes.SelectedValue));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] != null)
{
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
DropDownList dr1 = new DropDownList();
dr1 = (DropDownList)DetailsView1.FindControl("caName");
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/date/blog_Data.mdb";
sql_String.SelectCommand = "SELECT * FROM blogCategory ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
dr1.Items.Clear();
for (int i = 0; i < dv.Count; i++)
{
ListItem li = new ListItem(dv[i]["ca_name"].ToString(), dv[i]["ca_id"].ToString());
//li.Text = dv[i]["ca_name"].ToString();
//li.Value = dv[i]["ca_id"].ToString();
ca_id = dv[i]["ca_id"].ToString();
dr1.Items.Add(li);
ca_i++;
}
}
else
{
Response.Redirect("_boke.aspx");
}
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
CheckBox chb = (CheckBox)DetailsView1.FindControl("Man");
e.Values["TSex"] = chb.Checked ? "男" : "女";
e.Values["TPwd"] = Common.Getmd5("123");
}
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
HiddenField hidType = DetailsView1.FindControl("hidClientType") as HiddenField;
DropDownList dropType = DetailsView1.FindControl("dropClientType") as DropDownList;
dropType.SelectedValue = hidType.Value;
}
protected void IBtn_Update1_Click(object sender, EventArgs e)
{
TextBox TB = (TextBox)DetailsView1.FindControl("TextBox3");
string Tagstr = "<Script> window.open('Calendar.aspx?ClientID=" + TB.ClientID.ToString() + "','SelectDate','resizable=yes,scrollbars=no,top=200,left=240,height=350,width=400,status=no,toolbar=no,menubar=no,location=no','');</script>";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", Tagstr, false);
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
FileUpload file = (FileUpload)DetailsView1.FindControl("FileUpload1");
if (file.HasFile)
{
Label eid = (Label)DetailsView1.FindControl("Label1");
String id = eid.Text.Trim();//trim去掉首尾空格
string filename = file.FileName;
string path = Server.MapPath("~/img/") + filename;
file.SaveAs(path);
SqlDataSource1.UpdateParameters["Epic"].DefaultValue = "~/img/" + filename;
TextBox epic = (TextBox)DetailsView1.FindControl("TextBox1");
epic.Text = SqlDataSource1.UpdateParameters["Epic"].DefaultValue;
//连接数据库
String cnstr = @"Data Source=(LocalDB)\MSSQLLocalDB;" + "AttachDbFilename=|DataDirectory|Database1.mdf;" + "Integrated Security=True";
SqlConnection conn = new SqlConnection(cnstr);
//打开数据库连接
conn.Open();
//传入sql语句
String sql = "update Equipment set Epic='" + epic.Text + "' where Eid='" + id + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
else
{
SqlDataSource1.UpdateParameters["Eid"].DefaultValue = "";
}
}
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e)
{
//Response.Write("<script language='javascript'>confirm('Are you sure?')</script>");
string query = "DELETE FROM PRODUCTS WHERE ID = " + (((Label)DetailsView1.FindControl("lblId")).Text.ToString());
using (SqlConnection cnn = new SqlConnection(myConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
try
{
string image = Request.MapPath("Images/ProductImages/" + ((Label)DetailsView1.FindControl("lblImage")).Text);
cnn.Open();
cmd.ExecuteNonQuery();
Response.Write("<script language='javascript'>alert('Product removed from Database.')</script>");
System.IO.File.Delete(image);
DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
}
catch (Exception er)
{
Response.Write("<script language='javascript'>alert('Error has occured.')</script>");
System.Diagnostics.Debug.WriteLine(er.Message);
}
finally
{
cnn.Close();
UpdateGridView();
DetailsView1.DataBind();
}
}
}
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
FileUpload file = (FileUpload)DetailsView1.FindControl("FileUpload2");
if (file.HasFile)
{
string filename = file.FileName;
string path = Server.MapPath("~/img/") + filename;
file.SaveAs(path);
SqlDataSource1.InsertParameters["Epic"].DefaultValue = "~/img/" + filename;
//连接数据库
String cnstr = @"Data Source=(LocalDB)\MSSQLLocalDB;" + "AttachDbFilename=|DataDirectory|Database1.mdf;" + "Integrated Security=True";
SqlConnection conn = new SqlConnection(cnstr);
//打开数据库连接
conn.Open();
//传入sql语句
String sql = "insert into Equipment(Eid,Ename,Esize,Epic,Eprice,Edate,Eplace,manager)" +
"values('" + SqlDataSource1.InsertParameters["Eid"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Ename"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Esize"].DefaultValue + "'," +
"'" + SqlDataSource1.InsertParameters["Epic"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Eprice"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Edate"].DefaultValue + "'," +
"'" + SqlDataSource1.InsertParameters["Eplace"].DefaultValue + "','" + SqlDataSource1.InsertParameters["manager"].DefaultValue + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Close();
}
else
{
SqlDataSource1.UpdateParameters["Eid"].DefaultValue = "";
}
}
protected void dvDataSource_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
{
object o = e.ReturnValue;
IncomingFacture inFac = (IncomingFacture)o;
if (inFac.IncomingFactureType.Code == IncomingFactureType.ZA_POLISI)
{
GridView gvNewPolicies = (GridView)DetailsView1.FindControl("gvNewPolicies");
List <FactureInfo> lastFactureInfos = listFactureInfos;
GridViewRowCollection displayedRows = gvNewPolicies.Rows;
foreach (GridViewRow gvRow in displayedRows)
{
CheckBox cbIsForFacturing = gvRow.FindControl("cbIsForFacturing") as CheckBox;
int factureInfoID = Convert.ToInt32(gvNewPolicies.DataKeys[gvRow.RowIndex].Value);
FactureInfo fi = lastFactureInfos.Where(f => f.ID == factureInfoID).SingleOrDefault();
fi.IsForFacturing = cbIsForFacturing.Checked;
}
listFactureInfos = lastFactureInfos;
List <FactureInfo> listFactureInfo = listFactureInfos.Where(c => c.IsForFacturing == true).ToList();
foreach (FactureInfo fi in listFactureInfo)
{
IncomingFacturePolicyItem ifpi = new IncomingFacturePolicyItem();
ifpi.IncomingFactureID = inFac.ID;
ifpi.PolicyItemID = fi.ID;
ifpi.IsActive = true;
ifpi.Insert();
PolicyItem pi = PolicyItem.Get(fi.ID);
pi.PolicyIncomeFactureStatusID = PolicyIncomeFactureStatuse.GetByCode(PolicyIncomeFactureStatuse.CELOSNO_FAKTURIRANA).ID;
PolicyItem.Table.Context.SubmitChanges();
}
}
}
protected void dvDataSource_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
{
Packet p = (Packet)e.ReturnValue;
List <int> new_InsuranceSubTypeID = new List <int>();
List <PacketsInsuranceSubType> new_values = new List <PacketsInsuranceSubType>();
int packetID = p.ID;
CheckBoxList cbl = (CheckBoxList)DetailsView1.FindControl("InsuranceSubTypes");
foreach (ListItem item in cbl.Items)
{
if (item.Selected == true)
{
new_InsuranceSubTypeID.Add(Convert.ToInt32(item.Value));
}
}
foreach (int istID in new_InsuranceSubTypeID)
{
PacketsInsuranceSubType pist = new PacketsInsuranceSubType();
pist.InsuranceSubTypeID = istID;
pist.PacketID = packetID;
pist.BrokeragePecentageForPrivates = PacketsInsuranceSubType.GetDefaultBrokerageForPrivates(p.InsuranceCompanyID, istID);
pist.BrokeragePecentageForLaws = PacketsInsuranceSubType.GetDefaultBrokerageForLaws(p.InsuranceCompanyID, istID);
new_values.Add(pist);
}
PacketsInsuranceSubType.Table.InsertAllOnSubmit(new_values);
PacketsInsuranceSubType.Table.Context.SubmitChanges();
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
try
{
var fileUpload = (FileUpload)DetailsView1.FindControl("FileUpload2");
string fileToSave = String.Empty;
if (fileUpload.HasFile == true)
{
fileToSave = Server.MapPath("~/Image/" + fileUpload.FileName);
fileUpload.SaveAs(fileToSave);
}
else
{
return;
}
SqlDataSource4.InsertParameters["ImageFile"].DefaultValue = "~/Image/" + fileUpload.FileName;
}
catch (Exception ex)
{
throw ex;
}
}
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
int packetID;
if (GXGridView1.SelectedDataKey != null)
{
packetID = Convert.ToInt32(GXGridView1.SelectedDataKey.Value);
}
else
{
return;
}
List <PacketsInsuranceSubType> my_list = PacketsInsuranceSubType.GetByPacket(packetID);
CheckBoxList cbl = (CheckBoxList)DetailsView1.FindControl("InsuranceSubTypes");
foreach (ListItem item in cbl.Items)
{
foreach (var some in my_list)
{
if (item.Value == some.InsuranceSubTypeID.ToString())
{
item.Selected = true;
}
}
}
}
protected void deleteItem1(object sender, DetailsViewDeleteEventArgs e)
{
Label id = DetailsView1.FindControl("lbl_userId") as Label;
ClientHelper.deleteClientByID(int.Parse(id.Text));
Response.Redirect("logIn.aspx");
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
int packetID = Convert.ToInt32(e.Keys["ID"]);
List <PacketsInsuranceSubType> old_values = PacketsInsuranceSubType.GetByPacket(packetID);
List <int> new_InsuranceSubTypsID = new List <int>();
List <PacketsInsuranceSubType> new_values = new List <PacketsInsuranceSubType>();
CheckBoxList cbl = (CheckBoxList)DetailsView1.FindControl("InsuranceSubTypes");
foreach (ListItem item in cbl.Items)
{
if (item.Selected == true)
{
new_InsuranceSubTypsID.Add(Convert.ToInt32(item.Value));
}
}
foreach (int iID in new_InsuranceSubTypsID)
{
PacketsInsuranceSubType pist = new PacketsInsuranceSubType();
pist.PacketID = packetID;
pist.InsuranceSubTypeID = iID;
new_values.Add(pist);
}
PacketsInsuranceSubType.Table.DeleteAllOnSubmit(old_values);
PacketsInsuranceSubType.Table.Context.SubmitChanges();
PacketsInsuranceSubType.Table.InsertAllOnSubmit(new_values);
PacketsInsuranceSubType.Table.Context.SubmitChanges();
}
protected void EmailCustomValidation_ServerValidate(object source, ServerValidateEventArgs args)
{
string CS = ConfigurationManager.ConnectionStrings["TuteDB"].ConnectionString;
try
{
string newemail = ((TextBox)DetailsView1.FindControl("txtEmail")).Text;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("spValidateEmail", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", newemail);
con.Open();
bool validemail = Convert.ToBoolean(cmd.ExecuteScalar());
if (!validemail)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
}
catch (Exception exc)
{
lblError.Text = "Email Error " + exc.Message;
}
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
e.NewValues.Add("CreatedOn", Convert.ToString(DateTime.Now));
e.NewValues.Add("IsDeleted", false);
FileUpload fu = (FileUpload)DetailsView1.FindControl("FileUpload1");
if (fu.HasFile)
{
string UploadFolderRelativePath = "~/Uploads/";
string UploadFolderAbsolutePath = Server.MapPath(UploadFolderRelativePath);
string FullFilePath = string.Format("{0}/{1}", UploadFolderAbsolutePath, fu.FileName);
string FileRelativePath = string.Format("{0}/{1}", UploadFolderRelativePath, fu.FileName);
fu.SaveAs(FullFilePath);
e.NewValues.Add("ImagePath", FileRelativePath);
}
else if (!fu.HasFile)
{
HiddenField link = (HiddenField)DetailsView1.FindControl("TmageReload");
e.NewValues.Add("ImagePath", link.Value);
}
}
protected void DetailsView1_ItemCreated(object sender, EventArgs e)
{
TimeSpan startTime = new TimeSpan(7, 0, 0);
TimeSpan increment = new TimeSpan(1, 0, 0);
TimeSpan[] timeList = new TimeSpan[14];
//populate array with times incremented by an hour
for (int i = 0; i <= 13; i++)
{
timeList[i] = startTime;
startTime = startTime.Add(increment);
}
DropDownList ddl = DetailsView1.FindControl("ddlStart") as DropDownList;
if (ddl != null)
{
ddl.DataSource = timeList;
}
DropDownList ddl2 = DetailsView1.FindControl("ddlEnd") as DropDownList;
if (ddl2 != null)
{
ddl2.DataSource = timeList;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
TextBox txtUserID = DetailsView1.FindControl("txtUserID") as TextBox;
TextBox txtUserName = DetailsView1.FindControl("txtUserName") as TextBox;
DropDownList dropUserRole = DetailsView1.FindControl("dropUserRole") as DropDownList;
TextBox txtUserStatus = DetailsView1.FindControl("txtUserStatus") as TextBox;
TextBox txtUserLoginDate = DetailsView1.FindControl("txtUserLoginDate") as TextBox;
TextBox txtWrongAttempts = DetailsView1.FindControl("txtWrongAttempts") as TextBox;
int userID = Convert.ToInt32(txtUserID.Text.ToString());
string userName = txtUserName.Text.ToString();
string userRole = dropUserRole.SelectedValue.ToString();
string userStatus = txtUserStatus.Text.ToString();
string userLoginDate = txtUserLoginDate.Text.ToString();
string wrongAttempts = txtWrongAttempts.Text.ToString();
Debug.WriteLine("");
Debug.WriteLine("Data From Grid:");
Debug.WriteLine("User ID: " + userID);
Debug.WriteLine("User Name: " + userName);
Debug.WriteLine("User Type: " + userRole);
Debug.WriteLine("User Status: " + userStatus);
Debug.WriteLine("User Login Date: " + userLoginDate);
Debug.WriteLine("User Wrong Attempts: " + wrongAttempts);
DatabaseConnectivity dbcon = new DatabaseConnectivity();
int res = dbcon.setAUser(userID, userName, userRole, userStatus, userLoginDate, wrongAttempts);
//nt ResultQuery = dbcon.setAClient(userID, userName, userRole, userStatus, userLoginDate, wrongAttempts);
//Console.WriteLine("<script>alert(" + ResultQuery + "record has been updated." + ")</script>");
//ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery + "record has been updated." + ")</script>", true);
//ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery +")</script>", true);
DetailsView1.Visible = false;
//DetailsView1.Style.Add("display", "none");
_BindService();
}