public bool UpdateStatus(Model.clsStatus objStatus) { DataSet dsStatusList; dsStatusList = new DataSet(); SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@StatusID", SqlDbType.Int); objParam[0].Value = objStatus.StatusID; objParam[1] = new SqlParameter("@Status", SqlDbType.VarChar, 100); objParam[1].Value = objStatus.StatusName; int recaffected1; try { recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_UpdateStatus", objParam); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLStatus.cs", "UpdateStatus", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } return(true); }
public void dgStatus_Delete(object Sender, DataGridCommandEventArgs e) { try { objStatus = new Model.clsStatus(); objBLStatus = new BusinessLayer.clsBLStatus(); int intStatusID = Convert.ToInt32((dgStatus.DataKeys[e.Item.ItemIndex]).ToString()); objStatus.StatusID = intStatusID; recordcount = objBLStatus.DeleteStatus(objStatus); dgStatus.EditItemIndex = -1; GetStatusList(); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "StatusMaster.aspx", "dgStatus_Delete", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet IsDuplicateStatus(Model.clsStatus objStatus) { DataSet dsIsDuplicateStatus; SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@StatusID", SqlDbType.Int); objParam[0].Value = objStatus.StatusID; objParam[1] = new SqlParameter("@Status", SqlDbType.VarChar, 100); objParam[1].Value = objStatus.StatusName; try { dsIsDuplicateStatus = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_IsDuplicateStatus", objParam); return(dsIsDuplicateStatus); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLStatus.cs", "IsDuplicateStatus", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public bool UpdateStatus(Model.clsStatus objStatus) { try { if (objDLStatus.UpdateStatus(objStatus)) { return(true); } else { return(false); } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLStatus.cs", "UpdateStatus", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
protected void btnSubmit_Click(object sender, System.EventArgs e) { try { objStatus = new Model.clsStatus(); objBLStatus = new BusinessLayer.clsBLStatus(); objStatus.StatusName = Convert.ToString(txtStatus.Text.Trim()); // if(txtStatus.Text.Trim()=="") // { // lblDuplicateStatus.Visible=true; // lblDuplicateStatus.Text="Please enter a status"; // } // else // { dsIsDuplicateStatus = objBLStatus.IsDuplicateStatus(objStatus); if (dsIsDuplicateStatus.Tables[0].Rows.Count > 0) { lblDuplicateStatus.Text = "This status already exists"; } else { lblDuplicateStatus.Text = ""; recordcount = objBLStatus.AddNewStatus(objStatus); if (recordcount) { lblMsg.Visible = true; lblMsg.Text = "Record inserted successfully"; pnlAddEditStatus.Visible = false; GetStatusList(); } else { lblMsg.Visible = true; lblMsg.Text = "Error while inserting record"; } } // } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "StatusMaster.aspx", "btnSubmit_Click", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public void dgStatus_Update(object Sender, DataGridCommandEventArgs e) { try { objStatus = new Model.clsStatus(); objBLStatus = new BusinessLayer.clsBLStatus(); DataSet dsIsDuplicateStatus = new DataSet(); int intStatusID = Convert.ToInt32((dgStatus.DataKeys[e.Item.ItemIndex]).ToString()); TextBox strNewStatus = (TextBox)e.Item.FindControl("txtNewStatus"); DropDownList strIsActive = (DropDownList)e.Item.FindControl("ddlisActive1"); objStatus.StatusID = intStatusID; objStatus.StatusName = Convert.ToString(strNewStatus.Text.Trim()); if (objStatus.StatusName == "") { lblMsg.Visible = true; lblMsg.Text = "Please enter a status"; } else { dsIsDuplicateStatus = objBLStatus.IsDuplicateStatus(objStatus); if (dsIsDuplicateStatus.Tables[0].Rows.Count > 0) { lblMsg.Visible = true; lblMsg.Text = "This status already exists."; } else { lblDuplicateStatus.Text = ""; recordcount = objBLStatus.UpdateStatus(objStatus); dgStatus.EditItemIndex = -1; GetStatusList(); } } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "StatusMaster.aspx", "dgStatus_Update", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet IsDuplicateStatus(Model.clsStatus objStatus) { try { return(objDLStatus.IsDuplicateStatus(objStatus)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLStatus.cs", "IsDuplicateStatus", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }