public void GetBranchRecordValues(String _BranchrecID)
{
DataSet ds = new DataSet();
DataTable dt = null;
SqlDataAdapter da = default(SqlDataAdapter);
SqlConnection con = new SqlConnection(MyLocal.GetConnString(""));
string mSQLSTR = "SELECT B.BrAID,B.BCompID,B.BrName,B.BrAddress,B.BrCity,B.BrStateID,B.BrPinNo,C.CompName,S.StateName FROM tblBranch AS B LEFT OUTER JOIN tblCompany AS C ON B.BCompID = C.CompAID LEFT OUTER JOIN tblStates AS S ON B.BrStateID = S.StateAID WHERE B.BrAID=" + _BranchrecID + " AND (B.OurClientID=" + SVH.ClientID + ")";
mSQLSTR = "SELECT * FROM tblBranch WHERE BrAID=" + _BranchrecID + " AND (OurClientID=" + SVH.ClientID + ")";
da = new SqlDataAdapter(mSQLSTR, con);
da.Fill(ds, "tblBranch");
dt = ds.Tables["tblBranch"];
if (dt.Rows.Count > 0)
{
ddlCompanyName.SelectedIndex = ddlCompanyName.Items.IndexOf(ddlCompanyName.Items.FindByValue(dt.Rows[0]["BCompID"].ToString()));
//ddlCompanyName.Text = dt.Rows[0]["CompName"].ToString();
tbxBranchName.Text = dt.Rows[0]["BrName"].ToString();
tbxAdress.Text = dt.Rows[0]["BrAddress"].ToString();
tbxCity.Text = dt.Rows[0]["BrCity"].ToString();
//ddlBranchState.Text = dt.Rows[0]["StateName"].ToString();
ddlBranchState.SelectedIndex = ddlBranchState.Items.IndexOf(ddlBranchState.Items.FindByValue(dt.Rows[0]["BrStateID"].ToString()));
tbxPinNo.Text = dt.Rows[0]["BrPinNo"].ToString();
}
}
protected void btnDelConfNo_Click(object sender, EventArgs e)
{
divdelconf.Visible = false;
Branchentry.Visible = false;
lblfrommassage.Text = " " + tbxBranchName.Text + " in NOT Deleted Successfully";
grdSearchedBranch.DataSource = DelvedW.Common.SearchResult(MyLocal.GetConnString(""), "tblBranch", makeqstr());
grdSearchedBranch.DataBind();
//ClearEntry();
btnAddUpdDelBranch.Visible = true;
BtnCancel.Visible = true;
// lblfrommassage.Text = "";
}
private string CanItBeDeleted()
{
string mRetVal = "Yes";
if (DelvedW.Common.IsExist(MyLocal.GetConnString(""), "tblBooking", "BCompID=" + lblBranchAID.Text + " Where (OurClientID=" + SVH.ClientID + ")"))
{
mRetVal = "No";
lblfrommassage.Text = "Cannot Delete !! It is Already in Used in Booking";
}
return(mRetVal);
}
//protected void Page_Load(object sender, EventArgs e)
//{
//}
// CommonFunction check = new CommonFunction();
protected void Page_Load(object sender, EventArgs e)
{
// SVH.RefralURL = "~/masters/branches.aspx";
//if (!SVH.IsUserLogined.Equals("Yes"))
// Response.Redirect("~/admin/login.aspx");
if (Page.IsPostBack)
{
}
else
{
//http://forums.asp.net/t/1515775.aspx
//tbxBranchName.Attributes.Add("OnKeyPress", "return validateNumber(event)");
//tbxBranchName.Attributes.Add("onkeyup", "return ismaxlength(this,8)");
btnAddBranch.Enabled = true;
btnModifyBranch.Enabled = true;
btndeleteBranch.Enabled = true;
string tmpStr = "SELECT CompAID,CompName FROM tblCompany WHERE (OurClientID=" + SVH.ClientID + ") ORDER By CompName";
MyLocal.NewFillDDL(MyLocal.GetConnString(""), tmpStr, "CompName", "CompAID", ddlCompanyName);
MyLocal.NewFillDDL(MyLocal.GetConnString(""), tmpStr, "CompName", "CompAID", ddlsrchCompName);
tmpStr = "Select StateAID,StateName FROM tblStates ORDER By StateName";
MyLocal.NewFillDDL(MyLocal.GetConnString(""), tmpStr, "StateName", "StateAID", ddlBranchState);
//If Callied From Booking (Start)
string msqs = Request.RawUrl;
msqs = (msqs.Contains("?")) ? msqs.Substring(msqs.IndexOf('?') + 1) : "";
lblPassedCompID.Text = "";
//lblPassedCompID.Text = MyLocal.GetAnyValFromURL(msqs, "compid");
if (!(string.IsNullOrEmpty(lblPassedCompID.Text)))
{
if (lblPassedCompID.Text.Trim().Equals("error"))
{
lblfrommassage.Text = "Some Error in URL \\n Please Press Back Space \\nand go Back to Previous Page\\n";
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + lblfrommassage.Text.Replace("'", "\'") + "');</script>");
lblPassedCompID.Text = "";
}
else
{
AddButtonProcess();
ddlCompanyName.SelectedIndex = ddlCompanyName.Items.IndexOf(ddlCompanyName.Items.FindByValue(lblPassedCompID.Text));
}
}
}
}
//protected void MyLocal.ValidateRights(); //preventoperation()
//{
// if (SVH.UserType.ToLower().Equals("12") || SVH.UserType.ToLower().Equals("11") || SVH.UserType.ToLower().Equals("00"))
// {
// }
// else
// {
// SVH.Msg1 = "You Are Not Autherised To Do This Operation";
// Response.Redirect("/message.aspx");
// }
//}
protected void btnModifyBranch_Click(object sender, EventArgs e)
{
MyLocal.ValidateRights(); //preventoperation();
btnBackToMain.Visible = true;
btnAddBranch.Visible = false;
btnAddBranch.Enabled = false;
btnModifyBranch.Visible = false;
btnModifyBranch.Enabled = false;
btndeleteBranch.Visible = false;
btndeleteBranch.Enabled = false;
searchBranch.Visible = true;
ClearEntry();
btnAddUpdDelBranch.Text = "Update";
btnAddUpdDelBranch.Enabled = false;
lblPageHeading.Text = "Branch Modification Page";
}
protected void btnDelConfYes_Click(object sender, EventArgs e)
{
if (CanItBeDeleted().Equals("Yes"))
{
SqlConnection con = new SqlConnection(MyLocal.GetConnString(""));
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_DelBranch";
cmd.Parameters.Add("@Braid", SqlDbType.NVarChar).Value = lblBranchAID.Text;;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
lblfrommassage.Text = "Record Deleted successfully";
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
divdelconf.Visible = false;
//Student obj4delStudent = new Student();
grdSearchedBranch.DataSource = DelvedW.Common.SearchResult(MyLocal.GetConnString(""), "tblBranch", makeqstr());
grdSearchedBranch.DataBind();
Branchentry.Visible = false;
//ClearEntry();
btnAddUpdDelBranch.Visible = true;
BtnCancel.Visible = true;
lblfrommassage.Text = "";
}
}
protected void SearchDate()
{
lblSearchmsg.Text = "";
grdSearchedBranch.DataSource = DelvedW.Common.SearchResult(MyLocal.GetConnString(""), "tblBranch", makeqstr());
grdSearchedBranch.DataBind();
if (grdSearchedBranch.Rows.Count <= 0)
{
lblSearchmsg.Text = "No Records Found ! Please Search Again.";
}
// ClearEntry();
lblfrommassage.Text = "";
Branchentry.Visible = false;
btnAddUpdDelBranch.Visible = true;
btnAddUpdDelBranch.Enabled = true;
divdelconf.Visible = false;
}
public override void Do()
{
//1.打开光源
foreach (LightPara item in MyVisionPara.camLightPara.lightPara)
{
LightCtrlManager.Instance.SetLightValue(item);
}
//2.采图
if (GrabImg != null)
{
GrabImg.Dispose();
}
CameraCtrl.Instance.SetExpos(MyVisionPara.camLightPara.CamName, MyVisionPara.camLightPara.Exposure);
if (CameraCtrl.Instance.GrabImg(MyVisionPara.camLightPara.CamName, out GrabImg))
{
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_ok, 1); //拍照OK
}
else
{
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_ok, 2); //拍照NG
}
ViewControl view1 = DisplaySystem.GetViewControl(CameraTest.UpCam1);
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam0)
{
view1 = DisplaySystem.GetViewControl(CameraTest.UpCam1);
}
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam1)
{
view1 = DisplaySystem.GetViewControl(CameraTest.UpCam2);
}
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam2)
{
view1 = DisplaySystem.GetViewControl(CameraTest.UpCam3);
}
view1.ResetView();
view1.Refresh();
view1.AddViewImage(GrabImg);
view1.Repaint();
MyVisionBase.SaveImg(GrabImg, "扎针对位图片");
//3.关闭光源
LightCtrlManager.Instance.SetAllLightTo0();
//4.0设置定位模式
MyLocal.SetLocalModel(MyVisionPara.localPara.localSetting.localModel);
//5.0设置定位参数
MyLocal.SetParam(GrabImg, MyVisionPara.localPara);
//6.执行定位
try
{
MyLocal.doLocal();
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_result, 1); //告诉PLC定位结果OK
}
catch (Exception e0)
{
Logger.PopError1(e0, false, "视觉日志");
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_result, 2); //告诉PLC定位结果OK
}
//7.告诉PLC定位结果完成
MyLocalResult = MyLocal.GetResult();
view1.AddViewObject(MyLocalResult.ShowContour);
//结合标定坐标计算出产品的实际位置
MyHomMat2D HomMat = new MyHomMat2D();
HomMat = CaliParaManager.Instance.GetHomMAT(MyVisionPara.localPara.localSetting.CoordiCam); //获取示教的标定矩阵
HalconDotNet.HTuple HHomMat = new HalconDotNet.HTuple();
//标定矩阵的转换
MyVisionBase.MyHomMatToHalcon(HomMat, out HHomMat);
//图像坐标系的原点由左上角变到左下角
MyVisionBase.AdjImgRow(GrabImg, ref MyLocalResult.row);
St_VectorAngle PixelVector = new St_VectorAngle(MyLocalResult.row, MyLocalResult.col, MyLocalResult.angle);
CaliValue CaliPara = CaliParaManager.Instance.GetCaliValue(MyVisionPara.localPara.localSetting.CoordiCam);
//将像素坐标转换到标定坐标
//MyLocalResult.AffineTransResult()
HalconDotNet.HTuple HomMatCali = new HalconDotNet.HTuple();
MyVisionBase.MyHomMatToHalcon(CaliPara.HomMat, out HomMatCali);
MyVisionBase.AffineTransPt(MyLocalResult.col, MyLocalResult.row, HomMatCali, out MyLocalResult.x, out MyLocalResult.y);
//MyVisionBase.AffineTransPt()
//获取当前坐标
//double X = 0, Y = 0, Z = 0, Theta = 0;
//if (CaliParaManager.Instance.GetCaliMode(MyVisionPara.localPara.localSetting.TeachCoordi) == CaliModelEnum.HandEyeCali)
//{
// MotionManager.Instance.SetCoordi(MyVisionPara.localPara.localSetting.TeachCoordi);
// MotionManager.Instance.GetCoordiPos(out X, out Y, out Z, out Theta);
//}
//VectorAngle GrabPos = new VectorAngle(X, Y, Theta);
////9 计算出当前产品距离旋转中心的坐标
//EyeToHandPos.TransEyeToHandPos(PixelVector, CaliPara, GrabPos, out PosToRot);
////10计算出示教产品到旋转中心的坐标
//St_VectorAngle TeachPixelPos = new St_VectorAngle(MyLocalResult.TeachRow, MyLocalResult.TeachCol, MyLocalResult.TeachAngle);
//VectorAngle TeachGrabPos = new VectorAngle(MyLocalResult.TeachX, MyLocalResult.TeachY, MyLocalResult.TeachTheta);
//MyVisionBase.AdjImgRow(GrabImg, ref TeachPixelPos.Row);
//EyeToHandPos.TransEyeToHandPos(TeachPixelPos, CaliPara, TeachGrabPos, out TeachPosToRot);
//view1.Repaint();
//view1.SetString(100, 100, "red", "PosToRot: " + " X： " + PosToRot.Col.ToString("f3") + " Y： " +
// PosToRot.Row.ToString("f3") + " Theta： " + PosToRot.Angle.ToString("f3"));
//MyLocalResult.PosToRot = PosToRot;
//MyLocalResult.TeachPosToRot = TeachPosToRot;
}
public override void Do()
{
//1.打开光源
FileLib.Logger.Pop(" 打开光源：", false, "FOF运行日志");
foreach (LightPara item in MyVisionPara.camLightPara.lightPara)
{
LightCtrlManager.Instance.SetLightValue(item);
}
//2.采图
FileLib.Logger.Pop(" 开始采图：", false, "FOF运行日志");
if (GrabImg != null)
{
GrabImg.Dispose();
}
if (FilterImg != null)
{
FilterImg.Dispose();
}
CameraCtrl.Instance.SetExpos(MyVisionPara.camLightPara.CamName, MyVisionPara.camLightPara.Exposure);
if (CameraCtrl.Instance.GrabImg(MyVisionPara.camLightPara.CamName, out GrabImg))
{
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam2)
{
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_ok, 1); //拍照OK
}
FileLib.Logger.Pop(" 采图OK：", false, "FOF运行日志");
}
else
{
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam2)
{
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_ok, 2); //拍照NG
}
FileLib.Logger.Pop(" 采图NG：", false, "FOF运行日志");
}
ViewControl view1 = new ViewControl();
view1 = DisplaySystem.GetViewControl(CameraTest.UpCam2);
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam2)
{
view1 = DisplaySystem.GetViewControl(CameraTest.UpCam3);
}
view1.ResetView();
view1.Refresh();
//3.关闭光源
//LightCtrlManager.Instance.SetAllLightTo0();
//FileLib.Logger.Pop(" 关闭光源：", false, "FOF运行日志");
//4.0设置定位模式
MyLocal.SetLocalModel(MyVisionPara.localPara.localSetting.localModel);
//5.0设置定位参数
FileLib.Logger.Pop(" 开始偏移检测：", false, "FOF运行日志");
MyVisionBase.SaveImg(GrabImg, "FOF偏移检测图片");
if (MyVisionPara.camLightPara.IsFilter)
{
FileLib.Logger.Pop(" 开始频域滤波，FilterC：" + MyVisionPara.camLightPara.FilterC.ToString(), false, "FOF运行日志");
MyVisionBase.FilterImg(GrabImg, out FilterImg, MyVisionPara.camLightPara.FilterC);
view1.AddViewImage(FilterImg);
MyVisionBase.SaveImg(FilterImg, "FOF偏移检测图片");
MyLocal.SetParam(FilterImg, MyVisionPara.localPara);
}
else
{
view1.AddViewImage(GrabImg);
MyLocal.SetParam(GrabImg, MyVisionPara.localPara);
}
view1.Repaint();
//6.执行定位
try
{
FileLib.Logger.Pop(" 开始定位：", false, "FOF运行日志");
MyLocal.doLocal();
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam2)
{
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_result, 1);
}
FileLib.Logger.Pop(" 告诉PLC拍照结果OK（告诉PLC定位结果OK）：", false, "FOF运行日志");
}
catch (Exception e0)
{
if (MyVisionPara.camLightPara.CamName == CameraEnum.Cam2)
{
LD.Logic.PlcHandle.Instance.WriteValue(LD.Common.PlcDevice.FOF_Grabed_result, 2);
}
Logger.PopError1(e0, false, "视觉错误日志");
FileLib.Logger.Pop(" 告诉PLC拍照结果OK（告诉PLC定位结果NG）：", false, "FOF运行日志");
}
MyLocalResult = MyLocal.GetResult();
view1.AddViewObject(MyLocalResult.ShowContour);
view1.Repaint();
//8.结合标定坐标计算出产品的实际位置
MyHomMat2D HomMat = new MyHomMat2D();
HomMat = CaliParaManager.Instance.GetHomMAT(MyVisionPara.localPara.localSetting.CoordiCam); //获取示教的标定矩阵
FileLib.Logger.Pop(" 获取标定矩阵(CoordiEnumItem)：" + MyVisionPara.localPara.localSetting.CoordiCam.ToString()
, false, "FOF运行日志");
FileLib.Logger.Pop(HomMat.ToString(), false, "FOF运行日志");
HalconDotNet.HTuple HHomMat = new HalconDotNet.HTuple();
//9.标定矩阵的转换
MyVisionBase.MyHomMatToHalcon(HomMat, out HHomMat);
//10.图像坐标系的原点由左上角变到左下角
MyVisionBase.AdjImgRow(GrabImg, ref MyLocalResult.row);
MyVisionBase.AffineTransPt(MyLocalResult.col, MyLocalResult.row, HHomMat, out MyLocalResult.x, out MyLocalResult.y);
FileLib.Logger.Pop("col: " + MyLocalResult.col.ToString("f3") + " row: " + MyLocalResult.row.ToString("f3"), false, "FOF运行日志");
FileLib.Logger.Pop("X: " + MyLocalResult.x.ToString("f3") + " Y: " + MyLocalResult.y.ToString("f3"), false, "FOF运行日志");
MyLocalResult.Theta = MyLocalResult.angle;
if (FilterImg != null)
{
FilterImg.Dispose();
}
if (GrabImg != null)
{
GrabImg.Dispose();
}
}
protected void btnAddUpdDelBranch_Click(object sender, EventArgs e)
{
if (!btnAddUpdDelBranch.Text.Contains("Delete"))
{
if (ddlCompanyName.Text.Length > 0)
{
lblfrommassage.Text = "";
}
else
{
lblfrommassage.Text = "Company ID is required";
}
if (tbxBranchName.Text.Length > 0)
{
lblfrommassage.Text = "";
}
else
{
lblfrommassage.Text = "Branch Name is required";
}
if (!(lblfrommassage.Text.Length > 0))
{
if (tbxAdress.Text.Length > 0)
{
lblfrommassage.Text = "";
}
else
{
lblfrommassage.Text = "Branch Address is required";
}
}
if (!(lblfrommassage.Text.Length > 0))
{
if (tbxCity.Text.Length > 0)
{
lblfrommassage.Text = "";
}
else
{
lblfrommassage.Text = "Branch City is required";
}
}
if (!(lblfrommassage.Text.Length > 0))
{
if (ddlBranchState.Text.Length > 0)
{
lblfrommassage.Text = "";
}
else
{
lblfrommassage.Text = "Branch State is required";
}
}
if (!(lblfrommassage.Text.Length > 0))
{
if (tbxPinNo.Text.Length > 0)
{
lblfrommassage.Text = "";
}
else
{
lblfrommassage.Text = "Pin No. is required";
}
}
string mBrCompId = DelvedW.Common.GetValueFromTbl(MyLocal.GetConnString(""), "tblCompany", "LOWER(CompName)='" + ddlCompanyName.Text.ToLower() + "'", "CompAID");
if (!(lblfrommassage.Text.Length > 0))
{
string msDupChkStr;
if (btnAddUpdDelBranch.Text.Contains("Save"))
{
msDupChkStr = "LOWER(BrName)='" + tbxBranchName.Text.ToLower() + "' AND BCompId=" + mBrCompId + " AND (OurClientID=" + SVH.ClientID + ")";
}
else
{
msDupChkStr = "NOT BrAID=" + lblBranchAID.Text + " AND LOWER(BrName)='" + tbxBranchName.Text.ToLower() + "' AND BCompId=" + mBrCompId + " AND (OurClientID=" + SVH.ClientID + ")";
}
if (DelvedW.Common.IsExist(MyLocal.GetConnString(""), "tblBranch", msDupChkStr))
{
lblfrommassage.Text = "Branch Name " + tbxBranchName.Text + " is allready Existing";
}
else
{
lblfrommassage.Text = "";
}
}
if (btnAddUpdDelBranch.Text.Contains("Update") && (compaid1.Length > 0))
{
lblfrommassage.Text = "Record ID is Missing";
}
if (!(lblfrommassage.Text.Length > 0)) // = "Teacher"
{
if (btnAddUpdDelBranch.Text.Contains("Save") || (btnAddUpdDelBranch.Text.Contains("Update")))
{
SqlConnection con = new SqlConnection(MyLocal.GetConnString(""));
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = btnAddUpdDelBranch.Text.Contains("Save") ? "sp_AddBranch" : "sp_UpdBranch";
//if (btnAddUpdDelBranch.Text.Contains("Update") && (mguestAID4UnD.Length > 0))
if (btnAddUpdDelBranch.Text.Contains("Update"))
{
cmd.Parameters.Add("@braid", SqlDbType.Int).Value = lblBranchAID.Text; // mguestAID4UnD;
cmd.Parameters.Add("@uby", SqlDbType.NVarChar).Value = SVH.LoginedID;
cmd.Parameters.Add("@udt", SqlDbType.DateTime).Value = DateTime.Now.ToString();
}
else
{
cmd.Parameters.Add("@sessionid", SqlDbType.NVarChar).Value = SVH.SSessionID;
cmd.Parameters.Add("@urip", SqlDbType.NVarChar).Value = SVH.ClientIP;
cmd.Parameters.Add("@ourclientid", SqlDbType.NVarChar).Value = SVH.ClientID;
cmd.Parameters.Add("@isdeleted", SqlDbType.NVarChar).Value = "0";
cmd.Parameters.Add("@isactive", SqlDbType.NVarChar).Value = "1";
cmd.Parameters.Add("@aby", SqlDbType.NVarChar).Value = SVH.LoginedID;
cmd.Parameters.Add("@adt", SqlDbType.DateTime).Value = DateTime.Now.ToString();
}
//cmd.Parameters.Add("@bCompid", SqlDbType.NVarChar).Value = mBrCompId;
cmd.Parameters.Add("@bCompid", SqlDbType.NVarChar).Value = ddlCompanyName.Text.Equals("-- Select --") ? "0" : ddlCompanyName.SelectedValue.ToString();
cmd.Parameters.Add("@brname", SqlDbType.NVarChar).Value = tbxBranchName.Text;
cmd.Parameters.Add("@braddress", SqlDbType.NVarChar).Value = tbxAdress.Text;
cmd.Parameters.Add("@brcity", SqlDbType.NVarChar).Value = tbxCity.Text;
//cmd.Parameters.Add("@brstateid", SqlDbType.Int).Value = DelvedW.Common.GetValueFromTbl(MyLocal.GetConnString(""), "tblStates", "LOWER(StateName)='" + ddlBranchState.Text.ToLower() + "'", "StateAID");
cmd.Parameters.Add("@brstateid", SqlDbType.Int).Value = ddlBranchState.Text.Equals("-- Select --") ? "0" : ddlBranchState.SelectedValue.ToString();
cmd.Parameters.Add("@brpinno", SqlDbType.NVarChar).Value = tbxPinNo.Text;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
lblfrommassage.Text = "Record for Branch =" + tbxBranchName.Text + " is successfully ";
if (btnAddUpdDelBranch.Text.Contains("Save"))
{
lblfrommassage.Text = lblfrommassage.Text + "Inserted..";
}
else
{
lblfrommassage.Text = lblfrommassage.Text + "updated..";
}
}
catch (Exception ex)
{
throw ex;
// lblfrommassage.Text = "Not Inserted..";
}
finally
{
con.Close();
con.Dispose();
}
btnAddBranch.Enabled = true;
ClearEntry();
}
else if (btnAddUpdDelBranch.Text.Contains("Update"))
{
if (tbxBranchName.Text.Length > 0)
{
// obj4modStudent.ModifyStudentLogin();
}
// lblfrommassage.Text = obj4modStudent.StatusMessage;
grdSearchedBranch.DataSource = DelvedW.Common.SearchResult(MyLocal.GetConnString(""), "tblBranch", makeqstr());
grdSearchedBranch.DataBind();
Branchentry.Visible = false;
btnModifyBranch.Enabled = true;
//ClearEntry();
}
}
}
else if (btnAddUpdDelBranch.Text.Contains("Delete"))
{
divdelconf.Visible = true;
btnAddUpdDelBranch.Visible = false;
BtnCancel.Visible = false;
}
}
