private bool InsertDocumentStatus(string DocType, string fileName) { if (cmbFamilyDocNo.SelectedIndex < 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Select family number');", true); return(false); } else if (cmbVillage.SelectedIndex < 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Village');", true); return(false); } //else if (cmbDocumentNo.SelectedIndex < 0) //{ // ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select survey No.');", true); // return false; //} else { string DocumentID = dbDocumentStatusData.getDocumentSeqNo(); dbDocumentStatusData.documentid = Convert.ToInt32(DocumentID); dbDocumentStatusData.villagecode = cmbVillage.SelectedValue.ToString().Trim(); dbDocumentStatusData.familyno = ""; dbDocumentStatusData.surveyno = cmbDocumentNo.SelectedValue.ToString().Trim(); //Check Existing Title Search Exist dsDocumenttitleSearch = dbDocumentStatusData.DocumentTitleExistRO(cmbVillage.SelectedValue.ToString().Trim(), cmbFamilyDocNo.SelectedValue.ToString().Trim()); if (dsDocumenttitleSearch.Tables[0].Rows.Count > 0) { dbDocumentStatusData.titlesearchno = dsDocumenttitleSearch.Tables[0].Rows[0]["titlesearchno"].ToString(); } else { // dbDocumentStatusData.titlesearchno = cmbVillage.SelectedValue.ToString().Trim() + "_" + cmbFamily.SelectedValue.ToString().Trim() + "-" + cmbDocumentNo.SelectedValue.ToString().Trim() + "_" + DocumentID; dbDocumentStatusData.titlesearchno = cmbDocumentNo.SelectedValue.ToString().Trim(); } dbDocumentStatusData.docno = cmbFamilyDocNo.SelectedValue.ToString().Trim(); dbDocumentStatusData.documentcode = DocType; dbDocumentStatusData.documentname = fileName; dbDocumentStatusData.documentpath = ViewState["filepath"].ToString(); dbDocumentStatusData.createdby = "RSD"; dbDocumentStatusData.createddate = DateTime.Today; //Check For Record Exist dsDocumentexists = dbDocumentStatusData.DocumentExistRO(cmbVillage.SelectedValue.ToString().Trim(), cmbFamilyDocNo.SelectedValue.ToString().Trim(), DocType); if (dsDocumentexists.Tables[0].Rows.Count == 0) { bool DocInsert = dbDocumentStatusData.AddDocumentStatus(); } else { //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('File Already exist now updating');", true); // ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "element.onclick = function(){ return confirm('Are you sure you want to delete?'); };",true); bool DocumentFileUpdate = dbDocumentStatusData.UpdateDocumentFileRO(cmbDocumentNo.SelectedValue.ToString().Trim()); if (DocumentFileUpdate) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('New File updated');", true); } } return(true); } }