public SavingState SaveSrDsr(SRDSR srDsr) { SavingState svState = SavingState.Failed; if (!string.IsNullOrEmpty(srDsr.Name) && !string.IsNullOrEmpty(srDsr.CellNo)) { DbCommand thisCommand = null; try { thisCommand = GenericDataAccess.CreateCommand(); thisCommand.CommandType = CommandType.Text; /// if new sr if (string.IsNullOrEmpty(srDsr.Id)) { if (!IsSRDSRExist(srDsr.Name, srDsr.CellNo)) { thisCommand.CommandText = "INSERT INTO IM_SR_DSR (Id, Name, Type, CellNo) VALUES(@Id, @Name, @Type, @CellNo)"; CreateParameter.AddParam(thisCommand, "@Id", Guid.NewGuid().ToString(), DbType.String); } else { return(SavingState.DuplicateExists); } } else { thisCommand.CommandText = "UPDATE IM_SR_DSR SET Name = @Name, Type = @Type, CellNo = @CellNo WHERE Id = @Id"; CreateParameter.AddParam(thisCommand, "@Id", srDsr.Id, DbType.String); } CreateParameter.AddParam(thisCommand, "@Name", srDsr.Name, DbType.String); CreateParameter.AddParam(thisCommand, "@Type", (int)srDsr.Type, DbType.Int32); CreateParameter.AddParam(thisCommand, "@CellNo", srDsr.CellNo, DbType.String); GenericDataAccess.ExecuteNonQuery(thisCommand); thisCommand.Parameters.Clear(); svState = SavingState.Success; } catch (Exception ex) { if (ex.Message.ToLower().Contains("duplicate key")) { svState = SavingState.DuplicateExists; } } finally { if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed) { thisCommand.Connection.Close(); } } } return(svState); }
private SRDSR MapSrDsr(DbDataReader dr) { SRDSR srDsr = new SRDSR(); srDsr.Id = NullHandler.GetString(dr["Id"]); srDsr.Name = NullHandler.GetString(dr["Name"]); srDsr.Type = (SRType)NullHandler.GetInt32(dr["Type"]); srDsr.CellNo = NullHandler.GetString(dr["CellNo"]); return(srDsr); }