protected void btnsubmit_Click(object sender, EventArgs e) { dao.ContentNotesDAO objcontent = new dao.ContentNotesDAO(); Reportfunction obj1 = new Reportfunction(); ArrayList list = new ArrayList(); objcontent.Scompanyid = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString(); objcontent.SCreatedBy = ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID.ToString(); objcontent.STitle = Txttitle.Text; objcontent.SProcess = DDLprocess.SelectedItem.Value; for (int i = 0; i < grdDesc.VisibleRowCount; i++) { dao.ContentSubNotesDAO objsubcontent = new dao.ContentSubNotesDAO(); GridViewDataColumn c = (GridViewDataColumn)grdDesc.Columns[0]; // textbox column ASPxTextBox txtbox = (ASPxTextBox)grdDesc.FindRowCellTemplateControl(i, c, "txtsubtitle"); GridViewDataColumn c1 = (GridViewDataColumn)grdDesc.Columns[1]; // txtMemo column ASPxMemo txtMemo = (ASPxMemo)grdDesc.FindRowCellTemplateControl(i, c1, "txtDesc"); if (txtbox.Text.Trim() != "" && txtMemo.Text.Trim() != "") { objsubcontent.SSubTitle = txtbox.Text; objsubcontent.SSubDescription = txtMemo.Text; objsubcontent.SCompanyId1 = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString(); objsubcontent.SCreatedBy = ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID.ToString(); objcontent.AddContent(objsubcontent); } } objcontent.SFileName = Fileupload.FileName; Result result = new Result(); result = obj1.SaveNotesTransaction(objcontent); //obj1.addnotes(objcontent); }
//public int addnotes(dao.ContentNotesDAO obj ) //{ // conn = new SqlConnection(strsqlcon); // int result = 0; // try // { // conn.Open(); // comm = new SqlCommand("sp_Add_notes", conn); // comm.CommandTimeout = 500; // comm.CommandType = CommandType.StoredProcedure; // comm.Connection = conn; // comm.Parameters.AddWithValue("@sz_companyid", obj.IContentID.ToString()); // comm.Parameters.AddWithValue("@sz_title", obj.STitle.ToString()); // comm.Parameters.AddWithValue("@sz_process", obj.SProcess.ToString()); // comm.Parameters.AddWithValue("@sz_User_Id", obj.SCreatedBy.ToString()); // comm.Parameters.AddWithValue("@") // result = comm.ExecuteNonQuery(); // if (result == 1) // { // return result; // } // else if (result == -1) // { // return result; // } // } // catch (Exception ex) // { // _ex.Message.ToString(); // } // finally // { // if (conn.State == ConnectionState.Open) // { // conn.Close(); // } // } // return result; //} public Result SaveNotesTransaction(dao.ContentNotesDAO obj) { Result objResult = new Result(); conn = new SqlConnection(strsqlcon); conn.Open(); comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); SqlTransaction transaction; transaction = conn.BeginTransaction(); try { comm.CommandText = "sp_Add_notes"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@sz_title", obj.STitle.ToString()); comm.Parameters.AddWithValue("@sz_process", obj.SProcess.ToString()); comm.Parameters.AddWithValue("@sz_filename", obj.SFileName.ToString()); comm.Parameters.AddWithValue("@sz_user_id", obj.SCreatedBy.ToString()); comm.Parameters.AddWithValue("@sz_companyid", obj.Scompanyid.ToString()); //comm.ExecuteNonQuery(); SqlDataReader dr = comm.ExecuteReader(); string IContentID = ""; while (dr.Read()) { IContentID = Convert.ToString(dr[0]); } dr.Close(); ArrayList arr = obj.GetContain(); if (IContentID != null) { if (arr != null) { if (arr.Count > 0) { for (int i = 0; i < arr.Count; i++) { dao.ContentSubNotesDAO obj1 = (dao.ContentSubNotesDAO)arr[i]; comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "sp_add_detail_notes"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@id_mst_notes", IContentID); comm.Parameters.AddWithValue("@sz_userid", obj1.SCreatedBy.ToString()); comm.Parameters.AddWithValue("@sz_sub_title", obj1.SSubTitle.ToString()); comm.Parameters.AddWithValue("@sz_description", obj1.SSubDescription.ToString()); comm.ExecuteNonQuery(); } } } } transaction.Commit(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); transaction.Rollback(); } finally { conn.Close(); } return(objResult); }